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.
Will my Tasks for customers be brought over?
We will bring over Tasks, but due to how tasks work in WineDirect compared to Commerce7 those Tasks are imported as Notes. That means while you will have a record to review it will not have notification or follow up functionality in Commerce7.
Why are my customers getting notifications about zero dollar transactions?
Stripe is our primary gateway partner in Australia and New Zealand. As part of their system of tokenizing cards they run a zero dollar transaction for each card (regardless of if the card was imported with our migration or entered manually by you or the customer) to ensure the card is valid. This transaction won't appear on statements, but may appear as a Pending transaction or may trigger automated notifications on transactions for your customer.
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.
Why do my unfulfilled imported orders not deduct inventory when fulfilled?
Order history imported through the migration system cannot be linked to the inventory management system. Due to that, unfulfilled orders cannot automatically deduct from the inventory pools. To manage that, you can update the inventory counts manually under the Inventory System.
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.
How can I get orders that migrated without a customer account assigned to a customer?
You can search the order history in Commerce7 for the original WineDirect order ID number. Once you have the order up, you can follow the instructions here to assign a customer to an order.
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. Exchanges were the new balance is lower than the original the remaining will need to be refunded to cash, gift card, or external.
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.
Why did my SKUs change?
Commerce7 does not allow special characters or dashes within SKUs, so we convert SKUs to include dashes instead of periods and remove special characters.
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.
Why can I not sell products in my POS?
Imported products and inventory are tied to the Locations from your WineDirect site. You can change the default location for POS inventory by following the instructions on setting up locations here.