You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Does the V9 database have cross-indexing on tables now?
I did some massive deletes in the ecom_inventory and ecom_prod tables using phpmyadmin. But when I try to delete an inventory item in the V9 admin, it still shows an offer active even though it was deleted.
If there is indexing, how can I rebuild the database to fix the indexes?
Offline
No, there is no relational indexing, just a check in the code to make sure you're not about to shoot yourself in the foot with your item delete.
When you delete an inventory item a check is made against the ecom_pricemap table to identify any offers that might still exist. My guess is that you deleted the offers from ecom_prod (and/or ecom_amazonprod and/or ecom_ebayprod) but left the ecom_pricemap entries that provide the pricing for the offer-inventory item combination in the ecom_pricemap table.
Offline
Yes, that is what I did, then, since I deleted pages of product offers out of the ecom_prod table using phpmyadmin. I assume I can do the same out of the ecom_pricemap table using the xofferid and xinvid keys for inventory items?
Offline