0092 - 313-4567341
 info@magentogems.com

Importing Orders Into Magento

  Zahid Mughal   Oct 12, 2014   Blog   0 Comment

Big issue to import orders, Customers to Magento. You don’t need to wait any more. Not more than 10 minutes task to achieve this. But remember to take the database backup. Try to make this habit to take files and database backups to achieve any database level solution.

Just go to database, you phpmyAdmin, open the database and export all tables staring with sales_ and cutomers_
‘sales_bestsellers_aggregated_daily’;
‘sales_bestsellers_aggregated_monthly’;
‘sales_bestsellers_aggregated_yearly’;
‘sales_billing_agreement’;
‘sales_billing_agreement_order’;
‘sales_flat_creditmemo’;
‘sales_flat_creditmemo_comment’;
‘sales_flat_creditmemo_grid’;
‘sales_flat_creditmemo_item’;
‘sales_flat_invoice’;
‘sales_flat_invoice_comment’;
‘sales_flat_invoice_grid’;
‘sales_flat_invoice_item’;
‘sales_flat_order’;
‘sales_flat_order_address’;
‘sales_flat_order_grid’;
‘sales_flat_order_item’;
‘sales_flat_order_payment’;
‘sales_flat_order_status_history’;
‘sales_flat_quote’;
‘sales_flat_quote_address’;
‘sales_flat_quote_address_item’;
‘sales_flat_quote_item’;
‘sales_flat_quote_item_option’;
‘sales_flat_quote_payment’;
‘sales_flat_quote_shipping_rate’;
‘sales_flat_shipment’;
‘sales_flat_shipment_comment’;
‘sales_flat_shipment_grid’;
‘sales_flat_shipment_item’;
‘sales_flat_shipment_track’;
‘sales_invoiced_aggregated’;
‘sales_invoiced_aggregated_order’;
‘sales_order_aggregated_created’;
‘sales_order_aggregated_updated’;
‘sales_order_status’;
‘sales_order_status_label’;
‘sales_order_status_state’;
‘sales_order_tax’;
‘sales_order_tax_item’;
‘sales_payment_transaction’;
‘sales_recurring_profile’;
‘sales_recurring_profile_order’;
‘sales_refunded_aggregated’;
‘sales_refunded_aggregated_order’;
‘sales_shipping_aggregated’;
‘sales_shipping_aggregated_order’;

For Customers

‘customer_address_entity’
‘customer_address_entity_datetime’
‘customer_address_entity_decimal’
‘customer_address_entity_int’
‘customer_address_entity_text’
‘customer_address_entity_varchar’
‘customer_eav_attribute’
‘customer_eav_attribute_website’
‘customer_entity’
‘customer_entity_datetime’
‘customer_entity_decimal’
‘customer_entity_int’
‘customer_entity_text’
‘customer_entity_varchar’
‘customer_form_attribute’
‘customer_group’

Import in new website based on Magento and Boom.

To import customers and orders using CSV. Just export the orders and customers CSV from any platform and insert the proper attributes in CSV and then use import functionality of Magento.

If you need any help then message me at info@magentogems.com or magentogems@gmail.com

About Zahid Mughal

Founded by Zahid Mughal in Lahore, Pakistan, MagentoGems Providing Freelancing Services to Pakistan Software Houses and International Clients (USA, UK, Australia, India, Canada) in Web Design, Web Development, Mobile Applications, Search Engine Optimization (SEO), Graphic Design and Content Writing. Our core function is to meet the needs of our clients and provide them with services of the highest quality. To offer our clients the best websites in the market, we adhere to all the set W3C international standards. These standards ensure that our clients’ sites are compatible to various browsers and smart phone applications including the iPhones.

Post a Comment

Your email address will not be published. Required fields are marked *

*

Magentogems
Delta Road, Sharif Colony Gujranwala, 52250 +92-313-4567341
Read previous post:
Magento CMS 404 Error

Magento Admin Panel CMS page showing 404 error message. Follow the instructions to resolve the issue. GOTO phpMyAdmin, take database...

Close