This article will answer many of the commonly asked questions regarding data migration from WineDirect into Commerce7
Customer Data
Can customers be imported without an email address?
No, our tool requires valid email addresses for the import to be successful.
Can we add fake email addresses to our customer accounts?
We do not recommend adding fake email addresses to our customer accounts that errored out. Doing so could impact your email campaign by labeling your campaigns as spam accounts
Will missing an email address impact the import of our orders?
Our tool will import orders even if the corresponding customer account isn’t imported due to missing an email address. These orders will be imported as Guest Orders.
Order History Data
What can I do about the Order History errors?
Since order history cannot be edited in WineDirect, if orders are erroring out, please use the Order and Financial reports to back up your sales data for your own records.
My order history errors have "Customer does not exist," what can I do to fix that error?
Order history records with that error can be handled by fixing the related customer profile error. If you look at the Customer Errors file and search for the Customer Number for that customer you'll find the underlying error.
If the customer profile error cannot be corrected any order with the "Customer does not exist" error will still import on the final migration but will be moved to the Guest Customer account.
Most of the Order errors appear to be Tock orders. Can those be imported, anyway?
Order histories cannot be updated in WineDirect and our tool must have the subtotals equal the total (with tax and tip) to preserve your data integrity. Because of this, Tock orders will need to be backed up through your WineDirect reports.
My product sales reports do not show any tax information. What happened to it?
The order history report captures tax amounts at the order level, reflecting the total collected for the entire order, rather than on a per-product basis.
How can I refund orders that were migrated?
Migrated orders can only be refunded to a non-credit-card payment method, such as cash, gift card, or external. External is used if you are able to log in to the payment gateway where the transaction was processed and are able to process the refund there. The connection between the payment gateways of the original transaction and the order history cannot be migrated.
Exchanges where the remaining total is higher than the original order total can use a card to pay for the new balance.
Product Data
How can I ensure my product photos are imported?
We import only the main product image. If it's not in Commerce7, ensure the WineDirect image URL is valid and publicly accessible (no authentication). We support only one image domain, chosen based on a random product image URL - multiple image domains are not supported.
Why are there more inventory locations than I was expecting?
The import tool migrates pickup locations and inventory locations into the inventory pools system in Commerce7. We need to create those pools to ensure all inventory is accounted for after the import. If there are more inventory pools than you need, please only delete those after the final import is completed. We need to retain those pools until the final delta import date to ensure there are no inventory errors.
Locations
Why do I have duplicate locations?
The import tool migrates pickup locations and inventory locations into the inventory pools system in Commerce7. If a Pickup Location and an Inventory Pool in WineDirect have the same name our system will import both into Commerce7. It will look like there are duplicate locations, but they are separate with the same name. Please only delete those after the final import is completed. We need to retain those pools until the final delta import date to ensure there are no inventory errors.