Can't Upload Access db Products

[lbohen]

Today, our ShopSite Pro store was updated to SP2.

I tried to upload some Access db changes to our store like I have for years. I am unable to upload and our host believes that our Price field ($29.95) is causing the problem. They say the Price field is supposed to be a numeric field (without the $ sign). For years we have uploaded with our Price field as Currency with the $ sign.

Is anyone else experiencing this problem?

[gentlemans01]

We're running on ShopSite® Pro 10 sp2 r3.1

We use Access to manage db changes too, (output to txt then upload to server and import into shopsite) but I just checked our upload file and we don't have a currency sign on our format.

Per the db spec, price does exclude the currency symbol

We did a big rewrite of our access application last year, and there's a schema of all the fields in the knowledgebase.

Search for "Database Upload/Download Fields" in the knowledgebase at http://www.shopsite.com/help/10.2/en-US/sc/pro/index.htm?page=/help/10.2/en-US/sc/pro/dashboard.html

Price - The price of the product.

Field Type: Numeric entry (no currency symbol)

Default Value: 0.00

Possible Values: Any numeric value in standard currency format, but no currency symbol. You can include numeric and decimal separators, such as 1,234.56.

Comment: The currency symbol and price formatting are controlled by the settings on the Preferences Locale screen. You can set a sale price for a product with the Sale Amount field.

Maybe SP2 tightened the restriction on the upload formatting?

Good luck, hope this helps.

Chris