0

I am working on a Magento CE 1.7.0.2 site that contains Downloadable Products, all of which should only contain one link. It seems that some of these products contain two or more links and I need some way of finding out which products have this problem. Ideally this would be in the form of a spreadsheet with SKU against the number of links, but if I could even find out where this information is stored in the database that would be helpful!

I tried exporting Downloadable Products via System...Import/Export...Dataflow Profiles but I can only export links_exist, links_purchased_separately and links_title, none of which enable me to find the number of links for a product.

Many thanks for any help.

Improve this question

1 Answer 1

Reset to default
0

The fastest is by query

SELECT product_id, COUNT(*) toomuch
FROM downloadable_link
GROUP BY product_id 
HAVING toomuch > 1
Improve this answer
1
  • It's a pleasure!
    – Shadoweb
    Commented Oct 28, 2013 at 15:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.