-
Connex Commerce User Guide
- Getting Started with Connex Commerce
- Remote Desktop (RDP)
- Customers Matching
- Inventory Site
- Inventory Sync
- Multicurrency
- Orders
- Price Levels
- Products
- Refunds
- Sales Tax
- Sales Orders
- Unit of Measure
- Web Connector
- Getting Started with Rules
- Rules Engine Common Rules
- FAQ
- Deposit Match
- Cost of Goods Sold
- Troubleshooting
- Custom Store
- Billing
-
Connex Ecommerce Analytics
-
Frequently Asked Questions
-
General Troubleshooting Guide
- Deposit Match Troubleshooting
- QuickBooks Desktop Error Messages
- Inventory Troubleshooting
- Incorrect Orders Troubleshooting
- Sales Tax Troubleshooting
- Web Connector Troubleshooting
- QuickBooks Online Error Messages
- Match Deposit Tool Troubleshooting
- Product Matching Troubleshooting
- Customer Matching Troubleshooting
- Rules Engine
- Orders from QuickBooks
- Payments Troubleshooting
- Company File
-
Connex Commerce Integrations Guide
- Acumatica
- Amazon
- Amazon Settlement Report
- Bigcommerce
- CIN 7
- ERPAG
- FreeAgent
- Freshbooks
- Hubspot
- Keap
- Launchpad
- Magento 2
- Microsoft Dynamics 365
- Netsuite
- Odoo
- Paytrace
- Salesforce
- ShipBob
- ShipRush
- ShipStation to QuickBooks
- From QuickBooks to ShipStation
- Sage Business Cloud Accounting
- Sage Intacct
- ShipHero
- ShipWorks
- Shopify
- Square
- Stripe
- Veeqo
- Walmart
- WooCommerce
- Xero
- Zoho Books
-
Rules Engine Guide
Launchpad: How do I import customers from a spreadsheet?
Use spreadsheets to quickly import customers
How do I get a spreadsheet of products to import?
In this example, we will use QuickBooks Enterprise:
- In QuickBooks, go to lists > item list.
- On the bottom menu, click export.
- You need to rename the columns:
Launchpad | QuickBooks |
SKU | Item |
Description | Description |
Manufacturer | MPN |
Barcode | Barcode |
Remove all other columns.
How do I get a spreadsheet of customers import?
In this example, we will use QuickBooks Enterprise:
- In QuickBooks, go to customer center.
- On the top menu, click export.
- You need to rename the columns:
Launchpad | QuickBooks |
Company | Company |
Name | Name |
Remove | First name |
Remove | Last name |
Remove | Primary Contact |
Remove | M.I. |
Main Email | |
Phone | Main Phone |
BillToAddress1 | Bill to 1 |
BillToAddress2 | Bill to 2 |
BillToAddress3 | Bill to 3 |
ShipToAddress1 | Ship to 1 |
ShipToAddress2 | Ship to 2 |
ShipToAddress3 | Ship to 3 |
Line 3 of the billing and shipping address contains the city, state and zip. Our software will break out this fields accordingly. There is no need for a country code.
Launchpad
Once you get the spreadsheet, import it:
- In Launchpad, click customers on the left.
- On the right, click the ellipsis.
- Click import CSV.
- Import the CSV from QuickBooks.