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 without an attached customer account. If you need to reassign those orders to an existing or new customer account you can follow the steps outlined in this article.
Will my Tasks for customers be brought over?
We will bring over Tasks as Tasks within Commerce7, however since we can't assume a staff account exists within Commerce7 they will all be assigned to the Owner Admin account and must be reassigned after the import is completed.
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
Why are the order numbers different now?
The way we import orders requires that we import order history with new order numbers in Commerce7. However, we add the original WineDirect order ID number as an External Vendor record. This allows you to search by the original WineDirect order ID when using Commerce7.
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 not have a customer record attached. If you need to reassign those orders to an existing or new customer account you can follow the steps outlined in this article.
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.
Why are the items in the bundles not listed in my orders?
Migrated orders with bundle products only capture the SKU for the bundle, not the child SKUs under that bundle.
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 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.
Location Data
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. The purpose behind importing locations like this is to ensure orders and club memberships with pickup locations come over with error.
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 order or club membership 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.
Gift Card Data
Why didn't all my gift cards import?
Our tool imports only gift cards with balances over 1 whole dollar value. That means zero dollar, or values of pennies will not be imported.