Filename missing in Attributes.

[entangled]

Hello.

A Client's site suddenly is missing all of the Filenames in all of the Products in one of the Categories. Searching the Forum, I see this has happened before. The client does not recall what she did to cause this. And she did not catch it quickly enough before the DB backup rolled.

Looking at the Database, I use the products_id in products_attributes to get the products_attributes_id. I use the products_attributes_id to get the products_attributes_filename in products_attributes_download.

All looks good.

How do I get the filename to show up on the Product's Attribute without having to go through 1500+ Products by hand?

Thank you.

[mc12345678]

Confused, so when you went and looked at the database for an affected product and there was nothing wrong or was there something that had to be done?

What part of the whole business remains incorrect, what was done to make it "work"? Do the files still exist where expected? Any change(s) to the configure.php files?

[entangled]

Sorry for the confusion, I'll try to explain better.

There are 2 Categories selling Downloadable Products. When looking at the Product's Attributes from one of these Categories, the Downloads file appears:

Downloads: 1 files
Valid : 11-11-15NatHCdrTblDrsLegsUp07b.zip


However, when viewing a Product from the other Categories, the Downloads file does not appear:

Downloads: none


All the files are on the server and nothing has changed in configure.php is years. Again, one set of Products are fine, while the other set are all missing the Download filenames.

Looked the at the DB, everything appears to be fine:

In products_attributes_download:

1136 nat-BJ-hgti-blkdrs-DRtbl.zip

In products_attributes:

1136 955

In products:

955 1 1 nat-BJ-hgti-blkdress-s.jpg

So products_id = 955 is linked to products_attributes = 1136 and products_attrbutes = 1136 is attached to the download file. All the ID fields are filled in all the tables for all the Products.

I can not figure out how the filename gets attached to the Product's Attributes. I can Update the Attribute by putting the filename in by hand through the Zen-cart Admin, but, to do this for 1500+ Products would be a nightmare ... I can not figure out how to do this with SQL commands because I can not figure out what is wrong.

What I need to know is where, how or in what table(s) is the filename attached to the Product, because it doesn't appear to be in products, products_attributes or products_attributes_download.

I appreciate the help.

[mc12345678]

Sorry for not following through on this. I was at the time trying to find the information that you were seeking (table relationships), but lost site of the immediate need: update a mass quantity of products with download data.

Have you per chance come across EasyPopulate v4? (Search the forum, a thread exists for it and it handles files as well as other ZC aspects.) As a mental note, it will help do things en mass, but the product and attributes still need to be "built" in the sequence performed via the admin... Ie, can't apply filename attributes if the option name/value pair isn't yet assigned to the product. But can build that pair and apply it, then apply the attribute's filename.

[Ajeh]

Are you by any chance copying the Product with the working Attribute to a duplicate Product in the other Category?

Products copied as a Duplicate Product will lose their downloads ...

Products copied as a Linked Product will maintain their downloads ...