Reset "Next products table id" - Easy Populate

[dome90uk]

Does anyone know how to reset the "next products table id" that is displayed in the tools > Easy Populate - admin panel?



I added some test products using Easy Populate to make sure it was working and then deleted the products from the store. The products_id's no longer show the added product ids as they were deleted but the table id displayed in the admin is still counting the deleted products.

I am using EPA 3.0.3 and realise that it is probably outwith the remit of the community here to trouble shoot this but there is no support coming from the mod creator.

So if anyone can shed some light on how to adjust this number that would be great.

I have tried to track it down and it looks like it is being generated by the product id ( this is currently at 10 not 22 )

echo sprintf(EASYPOPULATE_PRODUCTS_INDEX_MODE, EASYPOPULATE_CONFIG_PRIMARY_INDEX);
if (EASYPOPULATE_CONFIG_PRIMARY_INDEX == 'products_id')
{
  echo sprintf(EASYPOPULATE_ADVICE_NEXT_PRODUCTS_ID, ep_get_next_id(TABLE_PRODUCTS));
} 

Any help appreciated, thanks.

[schoolboy]

You've got to be very careful here, because the product ID is not exclusive to the products table. It is used for a wide variety of relational processes (linking fields in OTHER tables to appropriate product data).

When you upload your products (either manually via the admin console) or through EP, a lot of additional processing takes place with the assignment of the product ID to other areas of the database.

re-setting the product ID in only the Products Table will result in an array of problems that you will find very challenging to repair.

[dome90uk]

Thanks for your help Schoolboy,

I have taken your advice and restored my shop to a previous version before the EP trials.