[khultquist]

I have 450 items where I need to add a new quantity break for item pricing. For example, right now Item ABCD has only a price for qty >= 0, but I need a price for qty >= 100.

I can manually add the quantity break and then import the price for each, but like I said I have 450 items, I don’t want to manually add quantity breaks all Christmas break… maybe if I had some elves to help me…

Is there any way to import/add/script this process? I looked through the ‘Records Browser’ and I can’t find a way to do it through script.
This is a cached copy. Click here to see the original post.

[Irma Scavello]

Hi,

I believe our CSV import allows you to accomplish this.

Please visit SuiteAnswers (or click on help link at top of any page) and review the topic: Importing Pricing Data for Items.

[khultquist]

RE: Add New Quantity Break For Item Pricing

Hi Irma – thanks for your response, but unless I am missing something the import process does not allow you to add a new quantity break, and I don’t see anything in the help file about it. Can you confirm this is possible?

Here’s a test CSV that I imported

Item,Price,Qty

ABCD,1.50,0

ABCD,0.75,100

The first line imported, but the second line returns this error

Error,Item,Price,Qty

Please enter missing quantity level(s),ABCD,0.75,100

I also tried it this way

Item,Price1,Qty1,Price2,Qty2

ABCD,1.50,0,0.75,100

And got this error

Error,Item,Price1,Qty1,Price2,Qty2

Please enter missing quantity level(s),ABCD,1.5,0,0.75,100

[khultquist]

OK I figured this out, I was importing the new qty break with a USD currency. But our global NetSuite account (OneWorld) was setup in Pesos, so when you add a new qty break it has to be in the global currency.

So I have to set a fictitious price in Pesos with the new qty break, then add the USD prices, then remove the fictitious Pesos prices.

[Author]

Posts