Add download product to exsiting order

[needlecreation]

I have a customer that ordered 4 items (all downloads), only two show up in her order. The download links were missing. I updates the links in the attribute controller and they have a green dot next to them. I then updated her order and the two products are still not showing up. How do I add the two products she did not get to her order or make a new order for the remaining two products so she can get a download button without having to pay again? Thanks for any help and suggestions.

[Ajeh]

Did you add the missing downloads to the:
orders_products_download

table to match the orders_id and orders_products_id and give the downloads and days to it?

[needlecreation]

Thank you for answering my thread. I don't believe I did this as I do not understand the answer. Could you walk me through how I find this table and where I need to go to change It? Thanks.

[Ajeh]

First, let's check and see what is in your database tables for this Order with the missing downloads ...

Go to your phpMyAdmin for your site and find your database for your site ... this is accessible through your Control Panel of your domain if you do not know how to find it ... if you still do not know how to find it, contact your hosting provider and ask them ...

Browse the table:
orders_products_download

Do you see entries in there for ALL of the downloads that this customer should be getting on this Order under the orders_id that is missing the 2 downloads?

[needlecreation]

I found the table, tho order id is 732 and only two fo the four downloads are listed. Can I add the two that are missing?

[Ajeh]

If you add them carefully, you should be able to add the new records by putting in the proper:
orders_id
orders_products_id
orders_products_filename
download_maxdays
download_count
products_prid

[needlecreation]

Ok, I know what to use for order_id,orders_products_filename,download_max_days, and
download_count,.
How do I know what to use for the order_products_download_id, the order products id and the products_prid?

[Ajeh]

order_products_download_id - leave blank this will assume the next value

order_products_id - this is the actual products_id that the downloads belong to ...

products_prid - this is a generated value of the products_id and the attribute for the download ... try just putting in the products_id again in this field and it should still work ...

[needlecreation]

Awesome! It worked! Thanks sooooooo much for walking me through it. I really appreciate your expertise.

[Ajeh]

You are most welcome glad that this was able to fix the Order for you with the missing downloads ...