Skip to main content

Data Upload : Terms and Conditions

Updated over 2 months ago

On this page

Overview of your Data Migration

  1. Corksy will work diligently with the client to export, clean, and map all data fields from the clients current CRM software, into the Corksy platform.

  2. We will map all fields that we are able to import based on the structure of our platform.

  3. We do not guarantee 100% data transfer as our platform is structured and operated in a way different than your current software provider. For this fact, we cannot upload all data with a 1:1 match.

  4. Corksy will work with the client to ensure all fields are mapped in the correct data structure and make as many revisions in a testing account as needed, to comply with the clients requests.

  5. Corksy will dedicate resources to each client to ensure this is completed to the best of our ability and will be open and transparent about any data we are unable to migrate.

  6. Corksy will outline to the client all changes to their data that are needed in order to upload successfully.

  7. Corksy and the client will discuss all of these changes via a 1:1 migration call with our migration team.

Processes of Data Migration

  1. The first data export will be managed via an Excel file. The client can request additional revisions or make the changes themselves in the file.

  2. Next, the client will approve of the changes in the Excel file.

  3. Once approved via email, Corksy will uploaded all the data into a testing (staging) account for further review.

  4. Once the client signs off on the staging (testing) account, Corksy will not make further or future changes.

  5. Corksy will download client data from their current CRM software during the migration onboarding process and again right before the client goes live.

  6. To ensure we meet these requirements, the client is required to go-live on the agreed upon go-live date,

Corksy Auto-Data Clean up

Automatic data changes (clean up) will be make by Corksy. The client will have the ability make changes if desired. If the client provides not response on these items, Corksy will assume all changes by our team are approved and will be uploaded.

  1. Missing email address will be changed to guest1@wineryname.com, guest2@wineryname.com, etc.

  2. Bad email address - Corksy will fix or change bad email addresses to guest1@wineryname.com, guest2@wineryname.com, etc.

  3. Missing birthday - Corksy will enter 01-01-2000

  4. Invalid birthday - Corksy will enter 01-01-2000

  5. Missing first name and last name - Corksy will enter Guest Customer

  6. Invalid address, missing zip codes - Address will be omitted from the upload

  7. Orders missing customer ID - Corksy will assign ID 1 to all orders. ID 1 = Guest Customer

  8. Customers missing customer ID - Corksy will assign an unused ID

  9. Re-mapping order type fields to identify with Corksy - Client must provide order ID mapping. Corksy will not upload data until this is identified.

  10. Re-mapping product type fields to identify with Corksy - Client must provide order ID mapping. Corksy will not upload data until this is identified.

  11. Duplicated emails - Corksy will delete records with duplicated email addresses. If the email address has a wine club attached, we treat this record as the primary.

    1. We are not responsible for order history lost in this process.

  12. Duplicated customer IDs - Corksy will change customer ID number if they are duplicated.

    1. We are not responsible for order history lost in this process.

  13. Duplicated order numbers - Corksy will delete orders with duplicated order ID numbers.

    1. We are not responsible for order history lost in this process.

  14. Duplicated products SKUs - If the client does not provide direction on product clean-up needs within 2 weeks, Corksy will change the duplicated SKU name to the product name.

    1. We are not responsible for making future changes to SKU name.

Testing (Staging) Account

  1. Corksy will upload all data with changes agreed upon by Corksy and the client into a testing (staging) account to visually see and interpret the data.

  2. While the data is in the testing account, the client will not use this account as their live Corksy account.

    1. This account is only for testing purposes and should never be directly edited, changes, or order placed through the system.

    2. If the client makes edits to this testing account, Corksy is not responsible for email notification, charges, or complaints made by customers of the account.

    3. This testing account is linked to the customers real email addresses and therefore, any edits or changes will trigger an email notification.

    4. Any changes in the data that need to be made in the testing account, will be communicated to Corksy via email or phone call. Corksy will be the only one responsible for making further changes to the data on the backend.

  3. Corksy will create as many testing accounts as needed to ensure the data is uploaded correctly during the migration.

  4. Once the client signs off on the staging (testing) account, Corksy will not make further or future changes. The client is responsible for making an manual changes to the data after this point. This includes:

    1. Manually deleting product that were initially indicated to be uploaded

    2. If product type is incorrect, client must manually delete the products and re-create them with the correct product type

      1. Corksy does not allow the changes of product types in the platform

    3. If brand is incorrect, client must manually delete the products and re-create them with the correct product type

      1. Corksy does not allow the changes of brand in the platform

    4. If any other product fields were incorrectly migrated and approved in the testing account, client must manually make these changes

    5. Order status must be manually changed by client if it is incorrect

      1. Client must manually change from Unfulfilled, Fulfilled, Restock, or vice versa

    6. If customer accounts with invalid email are uploaded, Corksy is not responsible for deleting or changing these records

      1. Client must manually change the email addresses in the customer accounts to the correct email address

Live (Production) Account

Once the client signs off and approve all data in testing account is correct and accurate before Corksy moves it into the live Corksy (production) account.

  1. When all orders, customer, and club member data is uploaded into the live Corksy (production) account, the client is able to use and operate Corksy. They are entitled to all data ownership and communication to their customers.

  2. Corksy will agree to upload product data into the live Corksy (production) account before the go-live data and before customers, orders, and club member is uploaded data, to ensure the client can build discounts and club requirements.

  3. Once the data is uploaded into the live production account,

    1. Corksy will map the shipping and billing addresses to the club member accounts

    2. Corksy will map customers to orders

    3. Corksy will map club members and members to card cards, if a credit card migration is taking place.

Go-Live Date

Corksy will download client data from their current CRM software during the migration onboarding process and again right before the client goes live. We will ensure that there is no data gap between the first data clean-up and the go-live date.

  1. To ensure we meet these requirements, the client is required to go-live on the agreed upon go-live date, unless unforeseen circumstances occur where Corksy is liable for the delay.

  2. On the go-live date, Corksy will upload all data into the clients production (live Corksy account)

  3. If the client delays the go-live date, the data gap will not be uploaded to the clients account

    1. Data integrity is upheld by Corksy to the highest standards. If you request changes to the data after it was already uploaded to your live Corksy account, we cannot honor these requests as they threaten the data integrity and quality.

  4. If the client continues to use their old system after the agreed upon go-live date, Corksy is not responsible for the data gap between the old CRM software and Corksy.

    1. This includes club member, orders, customer, and product new or changed data.

Credit Card Migration

  1. If a credit card migration is taking place, Corksy is not responsible for 100% data transfer of card numbers, expiration dates, CVC codes, or billing address details

  2. The client’s current credit card processor and current CRM software are responsible for transferring the tokenized card data to Corksy.

  3. Corksy will then map the tokenized card data to the customer IDs from the clients current system.

    1. Corksy is matching customer ID from the clients current system to the customer ID provided in the tokenzied credit card file.

    2. If a customer ID match is not available, Corksy cannot make the credit card match, and is not responsible for this loss in data.

  4. Corksy is not responsible for wine club processing that results in failed cards. Since Corksy is migrating tokenized card data provided by the clients current payment processor and current CRM software, we are not liabile for incorrect or expired data provided by these partners.

  5. Corksy is not responsible for wine club failed credit card processing due to security restrictions from the payment processor.

    1. Corksy respects the highest practices in data privacy and may have different security measures in credit card processing, compared to the client current CRM software.

  6. If a customer has multiple credit cards listed in the tokenized card file, Corksy will map the primary credit card to the membership, only if this data is available from the clients current CRM software.

    1. If this data is not exportable from the clients current CRM software, Corksy will migrate all credit cards in the tokenized card file, but we will not map the cards to the membership

      1. The customer or the client will be responsible for mapping AKA assigning the primary card to the club membership.

  7. Corksy maps billing address from the clients current CRM software to the the tokenized credit cards. Corksy does not receive billing address from the clients current payment processor. Therefore, Corksy is not responsible for failed cards during wine club processing due to outdated billing data.

Full list of fields Corksy is able to migrate

Order details fields available to migrate into Corksy:

  1. Customer Id

  2. Order Submitted Date

  3. Order Fulfilled Date

  4. Order Number

  5. Original Order Number

  6. Payment Status

  7. Compliance Status

  8. Fulfillment Status

  9. Channel

  10. Order Delivery Method

  11. Total Discount

  12. Discount Name

  13. Shipping Total

  14. Tax Total

  15. CRV Amount

  16. Subtotal

  17. Total

  18. Tip

  19. Total After Tip

  20. Customer First Name

  21. Customer Last Name

  22. Customer Email

  23. Customer Phone

  24. Bill To Birth Date

  25. Bill To First Name

  26. Bill To Last Name

  27. Bill To Address

  28. Bill To Address 2

  29. Bill To City

  30. Bill To State Code

  31. Bill To Zip Code

  32. Bill To Phone

  33. Bill To Country Code

  34. Bill Email

  35. Bill Company

  36. Ship To Birth Date

  37. Ship To First Name

  38. Ship To Last Name

  39. Ship To Address

  40. Ship To Address 2

  41. Ship Company

  42. Ship To City

  43. Ship To State Code

  44. Ship To Zip Code

  45. Ship To Country Code

  46. Ship To Phone

  47. Ship Email

Customer details fields available to migrate into Corksy:

  1. id

  2. First Name

  3. Last Name

  4. Birth Date

  5. Email

  6. Default Address Email

  7. Default Address Company

  8. Phone

  9. Notes

  10. Date Added

  11. Default Address Company

  12. Lifetime Value

  13. Default Address First Name

  14. Default Address Last Name

  15. Default Address

  16. Default Address 2

  17. Default Address City

  18. Default Address State Code

  19. Default Address Zip Code

  20. Default Address Phone

  21. Default Address Birth Date

  22. Bill To Birth Date

  23. Bill To First Name

  24. Bill To Last Name

  25. Bill Company

  26. Bill To Address

  27. Bill To Address 2

  28. Bill To City

  29. Bill To State Code

  30. Bill To Zip Code

  31. Bill To Country Code

  32. Bill To Phone

  33. Bill Email

  34. Ship To Birth Date

  35. Ship To First Name

  36. Ship To Last Name

  37. Ship Company

  38. Ship To Address

  39. Ship To Address 2

  40. Ship To City

  41. Ship To State Code

  42. Ship To Zip Code

  43. Ship To Country Code

  44. Ship To Phone

  45. Ship Email

Club member details fields available to migrate into Corksy:

  1. Customer Id

  2. Club

  3. Status Order

  4. Delivery Method

  5. Signup Date

  6. Cancel Date

  7. Cancellation Reason

  8. Notes

  9. Pickup Location

Product details fields available to migrate

  1. Product Name

  2. POS Title

  3. Description

  4. SKU

  5. Status

  6. ProductType

  7. Brand Name

  8. Bottle Size

  9. Bottle Units

  10. Color

  11. Variant Title

  12. AlcoholByVolume %

  13. Price

  14. Varietal

  15. Vintage

  16. Weight

  17. Varietal Composition

  18. Appellation

  19. Vineyard

  20. Harvest Date

  21. Acid

  22. PH

  23. Residual Sugar

  24. Bottling date

  25. Cases Produced

  26. Pairing Notes

  27. Tasting Notes

  28. Aging

  29. Vintage Notes

  30. Wine Making Notes

  31. Available on Wine club?

  32. Available on Online store?

  33. Available on POS?

Did this answer your question?