Forums / General Questions / Pop3 to Zen Cart, directly to mySQL db

Pop3 to Zen Cart, directly to mySQL db

Locked

Views: 864

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
1 Nov 2007, 6:45 PM
#1
stevekim avatar

stevekim

New Zenner

Join Date:
Apr 2007
Location:
Los Angeles, CA
Posts:
44
Plugin Contributions:
0

Pop3 to Zen Cart, directly to mySQL db

Hi,

Not being a programmer and wanting to do many makes it difficult. Though I find the forum very helpful...so I'm here again,

I'm thinking of starting to sell through Amazon, eBay, etc.
And before I do that, I'd like to establish the workflow right.
From my understanding, they only e-mail you to notify of the order, which means that it would be like having multiple websites that sell same items.

So I'd like to insert information contained in an e-mail notified by Amazon (and/or etc.) into Zen Cart as means of an integration. With it, I can manage my customers, orders, and their possible revisit directly back to my store rather than back to Amazon.

Now my questions are, assuming I've successfully extracted all information from the e-mail (using off the shelf text re-formatting software) and have a software that's authenticated to log into my DB:

  1. What would be the query statement to add a customer directly to the DB.
  2. What would be the query statement to add an order directly to the DB, using #1's customer number.
  3. What would be the query statement to add a shipping directly to the DB, using #2's order number.

I maybe missing some more critical questions to ask because above 3 are all I can think of when a single order is processed and passed on via email. Please suggest if more needs to be done.

Thanks in advance for you help!

Steve Kim.

**www.ToolUSA.com** - Hand Tools for Jewelers, Crafters, Garden and Households. Also offers Safety Items and Scout Gadgets.
**www.OfficialCap.com** - MLB Licensed Caps by New Era and NFL Licensed Caps by Reebok.

1 Nov 2007, 8:39 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Pop3 to Zen Cart, directly to mySQL db

#1 - you'll see the Zen Cart logic in /includes/modules/create_account.php
#2 and #3 - you'll see the Zen Cart logic in /includes/classes/order.php

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Nov 2007, 10:05 PM
#3
stevekim avatar

stevekim

New Zenner

Join Date:
Apr 2007
Location:
Los Angeles, CA
Posts:
44
Plugin Contributions:
0

Re: Pop3 to Zen Cart, directly to mySQL db

DrByte:

#1 - you'll see the Zen Cart logic in /includes/modules/create_account.php
#2 and #3 - you'll see the Zen Cart logic in /includes/classes/order.php

Thank you always, Dr. Byte!
I'll later post what how-I-did-it once it's complte.

**www.ToolUSA.com** - Hand Tools for Jewelers, Crafters, Garden and Households. Also offers Safety Items and Scout Gadgets.
**www.OfficialCap.com** - MLB Licensed Caps by New Era and NFL Licensed Caps by Reebok.