Anyone know how to import orders into Zencart?

[totalsam]

Hi,

I'm looking to import orders into ZC and was wondering if anyone knew of an add on or mod that can do this?

There seems to be alot of people who have created mods to export in various format has no one tried reversing this to import orders?

(specifically I wish to manually import amazon orders from their downloads)

Thanks

[kuroi]

I know of no add on or mod to do this. Theoretically, this import could be done, it's just a matter of populating the relevant tables with the data needed (though it would be difficult to generalise it into a mod). The difficult bit is making sure that the data in these tables is linked together correctly and makes use of the correct order statii.

The complexity is sufficient that, although we've converted a lot of client sites from other carts into Zen Cart, always convert the products, and usually convert the customers, we've yet to have a client who felt the cost of converting the orders would justify the return. And that's for a one-off conversion, a regular import would need to be more robust and therefore more complex.

[totalsam]

Would it be possible to manually import csv files straight into the database on the php my admin?

If so which tables would I need data for?

I would be prepared to have all the customers as simply "Amazon Customer" but would obviously need all the shipping addresses independant.

[schoolboy]

Er...

I think Kuroi just answered your initial question...

This is COMPLEX and DIFFICULT and EXPENSIVE and will require CUSTOM development...

Post for help in the Commercial Help Wanted section...

[totalsam]

Er...

I don't think you read my question. (tone noted)

It is very simple to upload things into the database manually - I know this. I just want to know how many and which tables I would have to upload things into to figure if it is worth bothering with or not.

[jackie.taferner]

totalsam,

It's not that simple, especially if you're importing from a non-zencart site. All the names of the database tables will not match, the structure of the tables is different, and will need to be manually changed before uploading into the new db. It's like fitting a square peg into a round hole.

On top of that you're going to need detailed customer data brought over, becuase without that, who made the orders, and for what shipping address? One customer cannot have thousands of names or addresses associated with them. You'll need these separated as different customers.

To answer your original question, there is no mod for this, because it would be impossible to make one. This needs to be done manually. It's not a simple process, you'll need a skilled zencart/mysql developer to do this for you.

[schoolboy]

Er...

By way of example...

The EasyPopulate main file - used to do the relatively simple task of bringing in product data (using a pre-determined format) - comprises about one-thousand-five-hundred separate lines of PHP.

Mull over this for a couple of hours:

To make the orders data relevant, and to have it properly associated (through relational protocols) you will need to bring data into the following tables:


address_book
FIELDS: address_book_id customers_id entry_gender entry_company entry_firstname entry_lastname entry_street_address entry_suburb entry_postcode entry_city entry_state entry_country_id entry_zone_id

address_format (could possibly be left out)
FIELDS: address_format_id address_format address_summary

customers
FIELDS: customers_id customers_gender customers_firstname customers_lastname customers_dob customers_email_address customers_nick customers_default_address_id customers_telephone customers_fax customers_password customers_newsletter customers_group_pricing customers_email_format customers_authorization customers_referral customers_paypal_payerid customers_paypal_ec

orders
FIELDS: orders_id customers_id customers_name customers_company customers_street_address customers_suburb customers_city customers_postcode customers_state customers_country customers_telephone customers_email_address customers_address_format_id delivery_name delivery_company delivery_street_address delivery_suburb delivery_city delivery_postcode delivery_state delivery_country delivery_address_format_id billing_name billing_company billing_street_address billing_suburb billing_city billing_postcode billing_state billing_country billing_address_format_id payment_method payment_module_code shipping_method shipping_module_code coupon_code cc_type cc_owner cc_number cc_expires cc_cvv last_modified date_purchased orders_status orders_date_finished currency currency_value order_total order_tax paypal_ipn_id ip_address

orders_products
FIELDS: orders_products_id orders_id products_id products_model products_name products_price final_price products_tax products_quantity onetime_charges products_priced_by_attribute product_is_free products_discount_type products_discount_type_from products_prid

orders_products_attributes
FIELDS: orders_products_attributes_id orders_id orders_products_id products_options products_options_values options_values_price price_prefix product_attribute_is_free products_attributes_weight products_attributes_weight_prefix attributes_discounted attributes_price_base_included attributes_price_onetime attributes_price_factor attributes_price_factor_offset attributes_price_factor_onetime attributes_price_factor_onetime_offset attributes_qty_prices attributes_qty_prices_onetime attributes_price_words attributes_price_words_free attributes_price_letters attributes_price_letters_free products_options_id products_options_values_id products_prid

orders_status
FIELDS: orders_status_id language_id orders_status_name

orders_status_history
FIELDS: orders_status_history_id orders_id orders_status_id date_added customer_notified comments

orders_total
FIELDS: orders_total_id orders_id title text value class sort_order

... and then of course if you have payment methods to consider... how did these customers pay for their products, you may have to import that data too ... eg: PayPal will require a few table imports, etc...

So er... yes...

Good luck

[jackie.taferner]

oh yes, schoolboy you have reminded me of another note. What use are importing the orders if the products are not brought over too? the products need to be imported so they can be associated with the past orders properly.

totalsam - So you'll need to import products (name, description, price, attributes, qty, images, etc), along with customer data (name, address, phone, login, etc), and then the orders (date, customer shipped to, payment method, products included, etc).

[totalsam]

Okay thank you for answering my question.

Now the payment method is simple, its all going to be Amazon Payments, which will already have been taken care of, all I am really concerned with is getting the order into my system so my staff can then process the order for dispatch. Amazon take care of the rest for me.

[schoolboy]

Oh... and Er...

If you happend to have sold a pair of Brown Shoes size 10, then you'll need to not only have the attribute set up for this, but data will also have to be imported into all the attributes (options) tables as well...