Skip to content

Shopify Order Importer

Menu Location: Tools > Import > Shopify Orders

Access Level: Administrator

Last Updated: 2026-03-01

Overview

The Shopify Order Importer tool imports orders from a Shopify store into your system. Useful for migrating from Shopify or syncing orders between platforms.

Primary Functions:

  • Connect to Shopify store via API
  • Import historical orders
  • Map Shopify products to your products
  • Import customer data
  • Sync order statuses
  • Schedule automatic imports

Page Layout

Header Section

  • Page title and description
  • Connection status indicator
  • Last import timestamp

Shopify Connection Panel

  • Store URL field
  • API key input
  • API password/token input
  • Test connection button
  • Save credentials button

Import Settings

  • Date range selector (import orders from/to)
  • Order status filter (fulfilled, pending, all)
  • Customer import option (create new customers or match existing)
  • Product mapping mode
  • Dry run option (preview without importing)

Product Mapping Table

  • Shopify product name
  • Your system product dropdown
  • Mapping status
  • Save mappings button

Import Progress

  • Progress bar
  • Orders imported count
  • Errors encountered
  • Success/failure log

Primary Features

Shopify API Integration

Connect directly to Shopify store using API credentials to fetch order data securely.

Product Mapping

Map Shopify products to equivalent products in your system. Required for accurate order import.

Customer Handling

Choose to create new customer accounts or match to existing customers by email address.

Dry Run Mode

Preview import results without actually creating orders. Review for accuracy before committing.

Automatic Scheduling

Set up recurring imports to keep orders synchronized between Shopify and your system.

Common Use Cases

Use Case 1: One-Time Migration from Shopify

Goal: Move all historical orders from Shopify to new platform

Steps:

  1. Obtain Shopify API credentials
  2. Enter credentials in Connection Panel
  3. Click "Test Connection"
  4. Set date range to cover all orders
  5. Map all products (Shopify → Your Products)
  6. Enable "Create new customers" option
  7. Run dry run to preview
  8. Review results
  9. Run actual import
  10. Verify orders imported correctly

Use Case 2: Daily Order Sync

Goal: Import new Shopify orders daily

Steps:

  1. Configure Shopify connection
  2. Map products
  3. Set date range: Yesterday
  4. Set order status: Fulfilled only
  5. Match existing customers by email
  6. Schedule automatic daily import
  7. Monitor import logs daily

Use Case 3: Map Shopify Products

Goal: Set up product mappings before import

Steps:

  1. Connect to Shopify
  2. Click "Load Products"
  3. Review Shopify product list
  4. For each product:
    • Select matching product from dropdown
    • Or create new product if needed
  5. Save mappings
  6. Test with dry run import

Use Case 4: Import Specific Date Range

Goal: Import orders from specific time period

Steps:

  1. Navigate to Shopify Order Importer
  2. Enter date range (e.g., January 1-31)
  3. Select order statuses to import
  4. Review product mappings
  5. Run dry run
  6. Review preview
  7. Import if correct

Use Case 5: Troubleshoot Failed Import

Goal: Fix and retry failed order imports

Steps:

  1. Review error log
  2. Identify failure cause (missing product mapping, invalid data, etc.)
  3. Fix underlying issue
  4. Re-run import for failed date range
  5. Verify success
  6. Document issue for future reference

Troubleshooting

Connection Failed

Symptoms:

  • Can't connect to Shopify
  • Error message about credentials
  • Test connection fails

Check:

  1. Verify API credentials are correct
  2. Check API key has required permissions
  3. Confirm store URL is exact (include .myshopify.com)
  4. Verify API key hasn't been revoked
  5. Check internet connectivity
  6. Contact Shopify support if persistent

Products Not Mapping

Symptoms:

  • Can't find matching products
  • Dropdown is empty
  • Import fails due to unknown products

Solutions:

  1. Create products in your system first
  2. Use exact product names when possible
  3. Manually map each Shopify product
  4. Consider creating temporary placeholder products
  5. Run dry run to identify unmapped products

Duplicate Orders Created

Symptoms:

  • Same orders imported multiple times
  • Order numbers duplicated
  • Customer complains about double billing

Check:

  1. Review import date ranges
  2. Verify import wasn't run twice
  3. Check for duplicate order detection setting
  4. Delete duplicate orders manually
  5. Adjust import settings to prevent recurrence
  • Import Tool - General CSV import functionality
  • Products - Manage product catalog
  • Orders - View imported orders
  • Customers - Manage customer accounts

Best Practices

Before First Import

  1. Back up your database
  2. Map all products first
  3. Run dry run and review carefully
  4. Test with small date range first
  5. Have Shopify data accessible for comparison

Product Mapping

  1. Map products before importing orders
  2. Use consistent naming conventions
  3. Document non-obvious mappings
  4. Review mappings quarterly
  5. Keep mapping table updated

Customer Handling

  1. Match by email when possible
  2. Review for duplicate customers after import
  3. Merge duplicates if needed
  4. Set customer communication preferences
  5. Verify customer contact information

Ongoing Sync

  1. Schedule imports during low-traffic hours
  2. Monitor import logs daily
  3. Alert on import failures
  4. Keep product mappings current
  5. Reconcile order counts monthly

Quick Reference Card

Task Action/Location
Connect to Shopify Enter credentials, click Test
Map products Product Mapping Table section
Set import range Use date range selectors
Preview import Enable dry run, click Import
Run actual import Disable dry run, click Import
View import log Scroll to Import Progress
Schedule auto-import Enable scheduling, set frequency
Fix failed import Review errors, correct, re-run

FAQs

Do I need to map every Shopify product?

Yes, unmapped products will cause import failures or create incomplete orders. Map all products before importing.

What happens to customers during import?

You can choose to create new customer accounts or match to existing customers by email. Matched customers won't create duplicates.

Can I import the same orders multiple times?

The system attempts to detect duplicates by order number, but it's best to avoid re-importing. Use date ranges carefully.

How long does import take?

Depends on order volume. Expect 1-5 seconds per order. 1,000 orders takes approximately 15-30 minutes.

Can I cancel an import in progress?

No, once started the import runs to completion. Use dry run to preview before running actual import.

Will imported orders affect inventory?

Yes, imported orders will adjust inventory levels as if they were regular orders. Review inventory after import.

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.