easypopulate 2.74 how to use own products_id

[atopman]

Hi, when i update my site, i clear the products/categories etc mysql tables. Then i upload again using easypopulate import, my site will have 1,000's of products, i want to use the products sku as this is fixed, as the products_id field. to keep reviews and orders etc intact. how do i get to use the products_id field in easy populate?

[♥geoffreywalton]

Try reading the documentation that comes with the contribution, that explains how to use the contribution.

 

Product_id is a numeric field used to link record in different tables together not hold sku's.

 

The SKU should be used as the product_model as this is the unique code that identifies eact part/product.

[atopman]

Try reading the documentation that comes with the contribution, that explains how to use the contribution.

 

Product_id is a numeric field used to link record in different tables together not hold sku's.

 

The SKU should be used as the product_model as this is the unique code that identifies eact part/product.

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. ?