Forums › Cached › CSV Import
This topic contains 7 replies, has 0 voices, and was last updated by ebodyboarding 10 years, 4 months ago.
-
AuthorPosts
-
June 4, 2014 at 2:19 pm #9150
ebodyboardingI have Googled and searched this forum and can’t seem to get the “Base Price” of an item to import from my csv file. It gives me this error:
Error: Please enter missing price(s)
I mapped the columns in the csv file like this:
http://awesomescreenshot.com/0ff2xbpv1f
USA > mapped to> Pricing 1 : Currency (Req)
My Base Price > mapped to> Pricing 1 : Price (Req)
Base Price > mapped to> Pricing 1 : Price Level (Req)
1 > mapped to> Pricing 1 : Quantity (Req)
What am I doing wrong?
Thanks!
Vicki
This is a cached copy. Click here to see the original post. -
June 5, 2014 at 5:13 am #9151
Olivier Gagnon NCMy guess is you have Quantity Pricing on. If you do, you must provide pricing for ALL quantity steps for all the price levels you wish to make updates to.
-
June 19, 2014 at 2:01 pm #9152
DewTry mapping the Quantity to 0 instead of 1.
-
July 18, 2014 at 11:14 am #9153
ebodyboardingNetsuite won’t help us because we haven’t paid for support. Arg! I have attached how we are mapping “Base Price” and the result. Can’t get the pricing to import. Anyone else have a solution?
Attached Files
-
July 18, 2014 at 12:19 pm #9154
ebodyboardingHere is our csv file:
https://drive.google.com/file/d/0B8P…it?usp=sharing
-
July 18, 2014 at 4:19 pm #9155
ebodyboardingI did it! Granted I had to take off “Quantity Pricing” from my Netsuite Enabled features. Base Price
Currency
Price Level60
USA
Base Price60
USA
Base Price60
USA
Base Price60
USA
Base Price60
USA
Base Price60
USA
Base Price60
USA
Base Price60
USA
Base Price -
July 22, 2014 at 6:44 am #9156
coffeeguyWe also use Qty pricing and do update the Base Price via CSV. If I recall one of the CSV options is to overwrite the entire price sub table with this new data.
AUS
Pricing 1 : Currency (Req)
Gross Price
Pricing 1 : Price (Req)
Base Price
Pricing 1 : Price Level (Req)
0
Pricing 1 : Quantity (Req)
-
July 22, 2014 at 1:42 pm #9157
ebodyboardingAwesome coffeeguy I will give that a try
-
AuthorPosts
You must be logged in to reply to this topic.