Results 1 to 8 of 8

Hybrid View

  1. #1
    Join Date
    Nov 2008
    Location
    Houston, Texas USA
    Posts
    33
    Plugin Contributions
    0

    red flag 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...


  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Add Products To Exsisting Order

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Nov 2008
    Location
    Houston, Texas USA
    Posts
    33
    Plugin Contributions
    0

    red flag Re: Add Products To Exsisting 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?

  4. #4
    Join Date
    Feb 2008
    Location
    Lake Havasu City, AZ - USA
    Posts
    79
    Plugin Contributions
    0

    Default Re: Add Products To Exsisting Order

    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.
    Joel Silverstein, VP COO
    Tech Diving Limited
    http://www.techdivinglimited.com

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Add Products To Exsisting Order

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Nov 2008
    Location
    Houston, Texas USA
    Posts
    33
    Plugin Contributions
    0

    Idea or Suggestion Re: Add Products To Exsisting Order

    Quote Originally Posted by Ajeh View Post
    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?

  7. #7
    Join Date
    Nov 2008
    Location
    Houston, Texas USA
    Posts
    33
    Plugin Contributions
    0

    Idea or Suggestion Re: Add Products To Exsisting Order

    Quote Originally Posted by JS1scuba View Post
    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...

 

 

Similar Threads

  1. How do I (admin) add more products to a costumer's order?
    By Djulli in forum Managing Customers and Orders
    Replies: 2
    Last Post: 22 Jun 2010, 11:45 PM
  2. Add obligatory clause to conclude order - Module Total Order
    By zildjian in forum Managing Customers and Orders
    Replies: 2
    Last Post: 7 Jun 2009, 06:41 PM
  3. Add spacing between products on Order Page?
    By drhiii in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 15 Oct 2008, 08:53 PM
  4. Manually Create Order / Add Products
    By VS4Hire in forum General Questions
    Replies: 0
    Last Post: 23 Aug 2007, 04:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg