0092 - 313-4567341

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 [email protected] or [email protected]

About Zahid Mughal

I have rich experience in WordPress Speed Optiomization which includes optimization of images, css, js, database and code. i’m also working as full-stack wordpress developer to provide PSD to HTML pixel perfect themes development, Plugins development. I’m also Certified (C|EH v.9) Ethical Hacker and having excellent skills in WordPress websites security, malware removal techniques, white-list websites from Google Black-list database. I’m also Top Ranked Website Security Analyst (Penetration Tester) Over $200k Earned at Upwork (2012-present) with both freelancing and agency profile. In WordPress website security, i mostly follow the best techniques to find and remove the vulnerabilities, backdoor from plugins, codes and database. WordPress website Code Audit is one of my favourite job.

Post a Comment

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

*

Magentogems
Delta Road, Sharif Colony Gujranwala, 52250 +92-313-4567341