Add Products To Exsisting Order

I have a strange situation. A customer ordered several products. They were processed with no problem. However the product, a download .zip file, was inadvertantly marked as .txt not .zip in the Atributes Controller. I have corrected this, but how do I get my customer the download link?

The product shows up on the order but without a download link.

Is there a way to remedy this in any way other than refunding the purchase of the errant items and having the customer re-order them?

Thanks in advance...

:oops:

Peek in the table:
orders_products_download

and see what the filename in the field:
orders_products_filename

is on the record(s) for that order ...

I must not have explained my situation correctly/completely.

I have 2 products that were purchased and they both appear in the Invoice. However they appear without the "File Type: .zip file" designation. They also do not have a download link on the customer's account page.

There is no entry for the 2 products in the orders_products_download table but the other products ordered are in the table.

How can I add a download link so my customer can get the products they paid for?

As simple as this sound. Send him an e-mail and embedd the link.

Dear Customer,

In error our system sent you a link to a text file. Please visit this link and download your product. The link will be active for 36 hours. If you do not download by then please contact us.

http://www.mywebstore.com/customer-name/fileyouneed.zip

We appreciate your consideration and apologize for the error.

Sincerely,
John. Q. Filesender

========================

Note -- whenever i have to do this for a customer I make a specific folder and put the file in there - i delete it within my time specified.

Hope this helps.

Cheers
JDS

PS -- we also sell software to our customers so i understand the problem.

You could add the records manually to the database tables:

If there is a Product record in the:
orders_products

then you need a record in the:
orders_products_attributes

and then you need a record in the:
orders_products_download

To help reproduce this correctly, you could make your own order so you can see how these records relate and fix what might be missing ...

JS1scuba:

As simple as this sound. Send him an e-mail and embedd the link.

Dear Customer,

In error our system sent you a link to a text file. Please visit this link and download your product. The link will be active for 36 hours. If you do not download by then please contact us.

http://www.mywebstore.com/customer-name/fileyouneed.zip

We appreciate your consideration and apologize for the error.

Sincerely,
John. Q. Filesender

========================

Note -- whenever i have to do this for a customer I make a specific folder and put the file in there - i delete it within my time specified.

Hope this helps.

Cheers
JDS

PS -- we also sell software to our customers so i understand the problem.

I was hoping to avoid this. What happens in the future when the customer wants to download again? Just a redundant question, no need to reply. I wish there was a way/mod to address this type of thing.

Although it would have been avoided in the first place if I had set the attribute correctly.

Thanks for the reply...

Ajeh:

You could add the records manually to the database tables:

If there is a Product record in the:
orders_products

then you need a record in the:
orders_products_attributes

and then you need a record in the:
orders_products_download

To help reproduce this correctly, you could make your own order so you can see how these records relate and fix what might be missing ...

Thanks for the reply. I was wondering which tables to 'touch' to add the product. But how about the link? it looks to be encoded in some way?

The records in the tables build the link in the customer's account for the order ...

If you are not sure what all records are need, make sure that your Attributes are setup correctly for your Product(s) and have the proper Download files on them ...

Recreate the order that your customer made with your own account and now you can see what records should have been created by the order ...