I have a site that was supposed to be live 10 days ago - the spreadsheet linking doesn't work - has anyone else had this problem?
The spreadsheet is erroring on the smallest spreadsheet, with one product row, I've cut it back to product reference, short desc and price - the problem is the price column - if I take it out, linking works. Put it back in, and it errors.
The column for price is a general formatted cell with the formula =int(PRICECOL*100) which puts the value 100 for a $1.00 price - I've even tried putting a value of 100 in there (no formula, just the value 100) - and it errors when I open the catalog.
On erroring, the unassigned products can NOT be moved to categories, they are stuck in the unallocated products category.
This is now driving me, and the client whose site is supposed to be live, totally CRAZY.
Due to the volatile nature of the product pricing, they need live linking of products to an external data-source - imports simply won't work as well.
regards
Web Your Business Inc.
The spreadsheet is erroring on the smallest spreadsheet, with one product row, I've cut it back to product reference, short desc and price - the problem is the price column - if I take it out, linking works. Put it back in, and it errors.
The column for price is a general formatted cell with the formula =int(PRICECOL*100) which puts the value 100 for a $1.00 price - I've even tried putting a value of 100 in there (no formula, just the value 100) - and it errors when I open the catalog.
On erroring, the unassigned products can NOT be moved to categories, they are stuck in the unallocated products category.
This is now driving me, and the client whose site is supposed to be live, totally CRAZY.
Due to the volatile nature of the product pricing, they need live linking of products to an external data-source - imports simply won't work as well.
regards
Web Your Business Inc.
Comment