ERP migration
Field-level mapping, validation, and rollback between eCommerce Pro and Acumatica. We move data and schema; workflows are rebuilt natively in Acumatica.
eCommerce Pro
Source
Acumatica
Destination
Compatibility
11 of 12
objects map 1:1 between eCommerce Pro and Acumatica.
Complexity
BStandard
Timeline
48–72 hours
Overview
eCommerce Pro stores organize product data around variants, images, and storefront-centric attributes like collections and tags. Acumatica organizes the same domain around StockItems with warehouse-level inventory tracked via AvailabilityScheme and multiple branch locations, plus financial integration through ARInvoices and shipment tracking. The migration maps product variants to Acumatica StockItems with a warehouse-scoping strategy for inventory, collapses customer records into Acumatica Customers with a default location per entity, and transforms eCommerce Pro orders into SalesOrders linked to the correct customer and inventory. eCommerce Pro shipping-method mappings require Acumatica-shipment-method value mapping, and any storefront discount logic that relies on eCommerce Pro's cart rules needs to be rebuilt as Acumatica's promotional pricing or discounts applied at the SalesOrder level. Acumatica's automation engine (SM205060) can replace abandoned-cart or post-purchase sequences, but these are not migrated automatically — we deliver a workflow map for your Acumatica admin to configure. The migration mechanism uses Acumatica's Import by Scenario (SM201020) for bulk data loads, with a delta-pickup window capturing any orders placed during cutover so Acumatica reflects the complete final state at go-live.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a eCommerce Pro object lands in Acumatica, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
eCommerce Pro
Product
Acumatica
StockItem (IN202000)
1:1eCommerce Pro products map to Acumatica StockItems. Each product variant in eCommerce Pro becomes a separate StockItem row with the base SKU stored as InventoryCD. Inventory N:1 against a single StockItem is resolved by splitting each variant into its own StockItem in Acumatica so warehouse availability tracks per SKU rather than per parent product.
eCommerce Pro
Product Variant
Acumatica
StockItem (IN202000)
1:manyeCommerce Pro variants (colour/size matrices) split into individual StockItem rows in Acumatica. The variant's combined attribute string is decomposed into separate values stored in the Item Class definition and custom fields (UsrColor, UsrSize) on the StockItem DAC. This avoids the Acumatica constraint where one StockItem cannot have conflicting availability by dimension.
eCommerce Pro
Product Image
Acumatica
File (SM202520) + ImageUrl field
1:1eCommerce Pro product images are downloaded and re-uploaded to Acumatica's file storage. We populate ImageUrl on the StockItem using the uploaded file URL. Image ordering (which image is primary) is preserved in a sort-order custom field (UsrImageSortOrder__c) since Acumatica has no native primary-image flag on StockItem.
eCommerce Pro
Inventory Level (per variant)
Acumatica
Item Warehouse (IN204000) per branch
1:1eCommerce Pro stock quantities per variant map to Acumatica Item Warehouse records per branch. If eCommerce Pro uses a single inventory pool and Acumatica has multiple branches, we apply the quantity to the primary branch and zero to others — your team specifies which branch is default or splits across locations before migration runs.
eCommerce Pro
Customer
Acumatica
Customer (AR303000) + Contact + Address
1:1eCommerce Pro customer records map to Acumatica Customers with a primary Contact and Address attached. Acumatica requires a Class ID on every Customer; we assign a default class (CUSTOMER) and flag records where a different class is recommended based on the customer's order volume or tax status for your admin to review post-migration.
eCommerce Pro
Customer Tag / Segment
Acumatica
Customer (AR303000) Note field or custom field
1:1eCommerce Pro customer tags and segments have no native Acumatica equivalent — Customer does not have a native tagging or segmentation object. We preserve tags as a delimited note on the Customer record or create a custom string field (UsrCustomerTags__c) for reporting and segmentation within Acumatica.
eCommerce Pro
Order
Acumatica
SalesOrder (SO301000) + ARInvoice (AR301000)
1:1eCommerce Pro orders map to Acumatica SalesOrders. For paid orders, the corresponding ARInvoice is generated. eCommerce Pro order status (pending, processing, completed, cancelled) maps to Acumatica SalesOrder status (On Hold, Pending, Open, Completed, Cancelled) based on the payment state and fulfillment state combination.
eCommerce Pro
Order Line Item
Acumatica
SalesOrder Detail (SO301000 line)
1:1Each order line in eCommerce Pro becomes a SalesOrderDetail line in Acumatica, linked to the target StockItem via InventoryCD. Line-level discounts from eCommerce Pro map to the Discount Amount field on the detail line; percentage discounts require an Acumatica Discount Code setup post-migration.
eCommerce Pro
Shipping Method
Acumatica
Carrier (CS205000) + Shipment
1:1eCommerce Pro shipping method names (e.g., 'Standard Shipping', 'FedEx Ground') are mapped value-by-value to Acumatica Carrier records. If no matching Carrier exists in Acumatica, we flag it for your admin to create before orders migrate. Shipping cost from the order is stored as a freight custom field on the SalesOrder (UsrFreightCost__c) for reconciliation.
eCommerce Pro
Discount / Coupon
Acumatica
Discount Code (SM200500) or SalesOrder Note
1:1eCommerce Pro discount codes and coupons have no direct Acumatica equivalent at the order level. Percentage and fixed-amount discounts applied at checkout are stored as line-level discount notes in the migration, and we provide a Discount Code setup guide for your Acumatica admin to configure the promotional rules post-migration so future orders apply discounts automatically.
eCommerce Pro
Product Category / Collection
Acumatica
Item Class (IN201000) + custom field
1:1eCommerce Pro product collections map to Acumatica Item Class hierarchy. We create Item Classes matching your top-level collection names and store the full collection path in a custom text field (UsrSourceCollections__c) on each StockItem so reports can filter by the original storefront taxonomy.
eCommerce Pro
Storefront Page / CMS Content
Acumatica
No equivalent — manual rebuild required
1:1eCommerce Pro CMS pages, blog posts, and URL slugs have no Acumatica equivalent — Acumatica is an ERP, not a CMS. We export page titles and URL slugs as a reference CSV so your web team can recreate the content and implement 301 redirects from the old storefront URLs to the new site.
| eCommerce Pro | Acumatica | Compatibility | |
|---|---|---|---|
| Product | StockItem (IN202000)1:1 | Fully supported | |
| Product Variant | StockItem (IN202000)1:many | Fully supported | |
| Product Image | File (SM202520) + ImageUrl field1:1 | Fully supported | |
| Inventory Level (per variant) | Item Warehouse (IN204000) per branch1:1 | Fully supported | |
| Customer | Customer (AR303000) + Contact + Address1:1 | Fully supported | |
| Customer Tag / Segment | Customer (AR303000) Note field or custom field1:1 | Fully supported | |
| Order | SalesOrder (SO301000) + ARInvoice (AR301000)1:1 | Fully supported | |
| Order Line Item | SalesOrder Detail (SO301000 line)1:1 | Fully supported | |
| Shipping Method | Carrier (CS205000) + Shipment1:1 | Fully supported | |
| Discount / Coupon | Discount Code (SM200500) or SalesOrder Note1:1 | Fully supported | |
| Product Category / Collection | Item Class (IN201000) + custom field1:1 | Fully supported | |
| Storefront Page / CMS Content | No equivalent — manual rebuild required1:1 | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
eCommerce Pro gotchas
URL structure changes destroy SEO value without redirect mapping
Dirty product data causes import failures and post-launch cleanup
Third-party integrations break after replatforming
Rushed testing misses checkout edge cases
Acumatica gotchas
API user licenses cap concurrent sessions and request throughput
Multi-tenant filtering requires CompanyID awareness
Custom fields require separate discovery before field mapping
Notes and attachments use a separate linked table structure
Implementation timelines frequently run 3–9 months end-to-end
Pair-specific challenges
Migration approach
Audit eCommerce Pro product and order data for variant explosion and open-order volume
FlitStack AI first pulls a full export of products, variants, customers, and orders from eCommerce Pro via its export API. We run a pre-migration audit that identifies products with more than 10 variants (flagging them for StockItem-split confirmation), customers with conflicting address records across orders, and open orders that will require Acumatica SalesOrder creation at cutover. The audit report is shared with your team before any schema work begins so you can confirm branch-scoping strategy and discount-code handling.
Pre-create Acumatica StockItem schema with custom fields and Item Classes
Before data loads run, your Acumatica admin (or our team) creates the custom fields on the StockItem DAC — UsrOriginID__c, UsrSourceCollections__c, UsrProductTags__c, UsrVariantLabel__c, UsrFreightCost__c, and others identified in the audit. Item Classes matching your top-level eCommerce Pro collection names are created in IN201000. Branch availability schemes are confirmed so the Item Warehouse records resolve correctly during migration. This step prevents the most common post-migration correction cycle: custom field creation after data is already loaded.
Resolve eCommerce Pro customers to Acumatica Customer records with Location strategy
eCommerce Pro customers are matched by email to Acumatica Contact records. Duplicate emails (one eCommerce Pro customer linked to multiple accounts) are flagged — your team decides whether to consolidate or create separate Customer records. For customers with multiple shipping addresses across orders, we create a primary Address and one Location per distinct shipping address. AcceptsMarketing flags and customer tags are stored in the UsrAcceptsMarketing__c and UsrCustomerTags__c custom fields. Total spent and orders count are stored in UsrTotalSpent__c and UsrOrderCount__c for CRM use post-migration.
Migrate StockItems in bulk via Acumatica Import by Scenario (SM201020) with variant splitting
Products and variants are loaded into Acumatica StockItems using Import by Scenario. Each variant becomes its own StockItem row with InventoryCD set to the variant SKU and the parent product title stored in Description. Inventory quantities are loaded into Item Warehouse records for the primary branch. File attachments (product images) are downloaded from eCommerce Pro and uploaded to Acumatica's file storage with URLs linked via ImageUrl or a custom URL field. A representative sample of 200–500 SKUs migrates first so you can verify variant splitting, image attachment, and inventory quantity accuracy before the full product catalog commits.
Migrate orders with ARInvoice generation and delta-pickup for in-flight orders
Historical and open orders are loaded as Acumatica SalesOrders with line items linked to migrated StockItems by InventoryCD. Paid orders trigger corresponding ARInvoices; refunded orders generate CreditMemos. Shipping method names are mapped to Acumatica Carrier records and the freight cost preserved as UsrFreightCost__c on the SalesOrder. During the cutover window, your team continues accepting orders in eCommerce Pro. A delta-pickup run (typically 24–48 hours) captures any new orders, new customers, or inventory changes that occurred during the transition so Acumatica reflects the complete final state at go-live. An audit log records every operation, and one-click rollback is available if reconciliation finds discrepancies.
Platform deep dives
eCommerce Pro
Source
Strengths
Weaknesses
Acumatica
Destination
Strengths
Weaknesses
Complexity grading
Standard ERP migration. 2 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across eCommerce Pro and Acumatica.
Object compatibility
2 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
eCommerce Pro: Varies by tier; Enterprise tier increases limits via negotiated SLAs.
Data volume sensitivity
eCommerce Pro exposes a bulk API — large-volume migrations stream efficiently.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during eCommerce Pro to Acumatica migration scoping. Not seeing yours? Book a call.
Walk through your eCommerce Pro to Acumatica migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave eCommerce Pro
Other ways to arrive at Acumatica
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.