Quote Originally Posted by keith z View Post
I have about 13K linked items in a product category folder. I thought that the category could contain sub categories or items not both. Somehow I have done this and created duplicate items from another product sub-category. I understand about deleting the items with product status 9. That removes both items because they are linked and the ID number is the same. I'm ok with reloading the file which re installs the item with a different master ID.

Since I am trying to submit a file for google shopping this action makes my product link invalid and ruins my day. Is there a way to download the master ID number so I can update the product link so it works? In previous version I used the froogle tab to download the file. Since upgrading I am limping along trying to keep my old files updated.

I am using Zen cart 1.54 and Easy Populate 4.0.28 - Beta 01-03-2015
So, yes it is correct that a category should contain either sub-categories or products not both. It is something that is still allowed to be done (though doesn't provide desired results) in ZC, but typically requires the sub-categories to be disabled in order to add a product to the category that has a sub-category(ies)... So, yes the same thing could end up happening while using EP4 at this time.

It would be better to not go and "recreate" the store with all new product ids, but instead to resolve the current issue and a process to not have it reoccur. First things first, do you normally have linked product or was this something that mistakenly happened? Depending on the status of things, and the expected condition, may be able to run a SQL command to remove the linked items from the undesirable location(s)... But a little bit of information would help (if assistance is being sought... If able to do on your own, maybe would share the solution discovered.)

The additional product data field values can be pulled using the User Defined Products Fields field in admin->configuration->Easy Populate 4.
Provide the field name that is desired to obtain from the Products table as listed in the products table (ie. master_categories_id). Do not add the prefix ("v_") that you are accustomed to seeing in the export file.

As for froogle, the ability to download/export the full URI was provided to support froogle related/historical download of information.. Admin->configuration->Easy Populate 4->Export URI with Prod and or Cat. Is there something more that is needed to support that "effort"? Just because I'm a non-user doesn't mean the additional information/formatting can't be added, just need some help/input... :)