Using Excel for products update - Using both Text & form

[DHPatrick]

We use pricing lists from multiple vendors provided to us in Excel Worksheets. Most of our products have multiple quantity breaks and pricing: 100 @ US$1.00 250 @ US$0.95 500 @ US$0.90...etc.

We are trying to use the Quantity Pricing format that Shopsite needs while pulling quantity information and pricing information from multiple cells to one cell.

checked|n|6|n|Minimum Order" Worksheet!P2, " pieces Imprinted. Price includes one color, one location imprint.|n|#FFFFFF|#FFFFFF|#FFFFFF|n|P2|Q2||n|R2|S2|.....ect.
Where P2 = quantity, Q2 = price, R2 = quantity, S2 = price @ R2 quantity.

Does anyone know how to make this work????????

[robm]

You can view the documentation on how this upload field should be formatted at:
http://www.shopsite.com/help/9.0/en-US/ ... ields.html

From that page:

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.