This topic contains 7 replies, has 0 voices, and was last updated by ebodyboarding 10 years, 4 months ago.

  • Author
    Posts
  • #24011

    ebodyboarding

    I 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.

  • #24012

    Olivier Gagnon NC

    My 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.

  • #24013

    Dew

    Try mapping the Quantity to 0 instead of 1.

  • #24014

    ebodyboarding

    Netsuite 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

  • #24015

    ebodyboarding

    Here is our csv file:

    https://drive.google.com/file/d/0B8P…it?usp=sharing

  • #24016

    ebodyboarding

    I did it! Granted I had to take off "Quantity Pricing" from my Netsuite Enabled features. Base Price
    Currency
    Price Level

    60
    USA
    Base Price

    60
    USA
    Base Price

    60
    USA
    Base Price

    60
    USA
    Base Price

    60
    USA
    Base Price

    60
    USA
    Base Price

    60
    USA
    Base Price

    60
    USA
    Base Price

  • #24017

    coffeeguy

    We 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)

  • #24018

    ebodyboarding

    Awesome coffeeguy I will give that a try

You must be logged in to reply to this topic.