Originally Posted by
easy3dsource
First off, thanks for updating easypopulate to work with ZC 1.5!
I recently had to do some manual database troubleshooting and as part of the process I ended up installing this version of easypopulate. Prior to that I was using 1.2.5.4 on a ZC 1.5 installation. (With this version I couldn't access easypopulate through the admin menu, but could access it if I added "easypopulate.php" after the admin URL.)
So my problem: I run a shop that sells only downloadable products. I always used easypopulate to upload all products, then in order to keep the downloadable files properly attributed to the products I would manually update the zen_products_attributes and zen_products_attributes_downloads tables of the database by using excel, then uploading via phpmyadmin.
For the sake of my sanity, I always made sure that the last 3 digits of the model number for each product (used in the easypopulate spreadsheet) matched the last 3 numbers of the product_id in the database. This always worked fine, up until recently;
We had to delete some products through the admin (not using easypopulate), in order to keep our model numbers serialized, we adjusted our spreadsheets so that the next new products added just took the place (by way of model number, and product_id) of the deleted products.
Once we uploaded our new spreadsheets, we noticed that easypopulate is skipping product id's; We currently have 238 products, if we upload a new product, we'd like the product id to be 239, but it's currently jumping to 270. After doing a number of tests, I noticed a couple things:
-let's say I upload a test product via easypopulate, and it got assigned the product_id 270
-if i manually delete traces of this product via phpmyadmin then re-upload the spreadsheet it takes the same product_id as before
-if I delete the product through the ADMIN, then re-upload the spreadsheet, it gets assigned the NEXT product_id, in this case, 271.
So what I'm wondering is if zen cart somehow stores the product_id's of deleted products, making them unassignable to new products? This is causing a problem because I'd rather not have a gap in the product ID's (it helps me and my partner maintain the inventory easier).
Once again; what I'm trying to solve here is how to make sure when I upload new products via easypopulate, there isn't a jump in the product_id.... anyone have any thoughts / suggestions on how to make this happen?
Thanks in advance!
Bookmarks