quantity discount upload

[VinceP]

I have a database in my Peachtree program that I can send to Excell but it has separate price columns for my quantity discount prices (price 1, price 2, price 3). All of my items have 3 price breaks 1 to 11 12 to 143 and 144 or more. Is there a way to upload these other prices into the database. When I look at the shopsite database all of the quantity discounts seem to be in one column and only the single price has a separate column.

[Jim]

The upload format is documented in the help at
http://shopsite.com/help/10.0/en-US/sc/ ... ields.html
===============================
Quantity Pricing - Information to create a quantity pricing table for this product.

Field Type:

Restricted Text Entry
Default Value:

Null; there is no default value.
Possible Values:

Variable number of values separated by a | symbol or |n|, in this format:

CHECKED|n|X|n|COMMENT|n|COLOR1|COLOR2|COLOR3|n|Q|PRICE|SALE|n|
.

The values are:

* The first value is CHECKED if Quantity Pricing is enabled for this product, otherwise it is n, and the rest of this field can be ignored.
* The second value (X) sets the number of price breaks. Note that this is the maximum number used for this product, but the actual number of price breaks in use may be less.
* . The COMMENT value is the comment that will appear below the Quantity Pricing table on store pages.
* The COLOR values set the color for the quantity row, price and comment row, and on sale row in the table, respectively.
* The Q value is the starting quantity for a quantity range.
* The PRICE value is the price per unit for this quantity range.
* The SALE value is the sale price for this quantity range.

The Q|PRICE|SALE|n| is repeated for each quantity range.
=========================================
So the format for 4 items would be
CHECKED|n|4|n|COMMENT|n|COLOR1|COLOR2|COLOR3|n|Q1|PRICE1|SALE1|n|Q2|PRICE2|SALE2|n|Q3|PRICE3|SALE3|n|Q4|PRICE4|SALE4|n|

You should be able to build the string of fields that are needed from your data and put it all into one column of your file and then use that column for the quantity pricing for the products