Hello geoffrey, i have read it and have been using it succesfully for 10,ooo items in stock out of 30,000.
I didnot want to keep 30,000 items in the database with only 1/3rd in stock, and the manegemnet of it becomes more cumbersome timewasting, and the customers would be annoyed. so
now, i thought to use only the in stock items. But, because the product id is used by the system, when i upload the latest stock list, naturally the product id no longer matches the previous upload. so the reviews etc get mixed up.
The sku numbers are unique, and so i wanted to use that as the product id, to get round this issue.
I was wondering how to do that with what i have already, or maybe i have to try a different version, i have heard of advanced version, that has product id filed, where is that, if it is suitable?
Currently i am experimenting with access, and odbc connection, i can get the tables, once...and am keeping the connection alive ok, but after i close the table, i think the server times out after 30 seconds, and i cannot reconnect to the table. i can only reconnect , if i restart access. is that normal ? surelt the server should enable a reconnection after a timeout. ?