- Connex Ecommerce Analytics
- Product Management
-
Connex for QuickBooks User Guide
- Getting Started with Connex for QuickBooks
- 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
-
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 for QuickBooks Integrations Guide
-
Rules Engine Guide
How does Connex Inventory Planner work when my product has no SKU?
Map the SKU, delete and resync sales
What if my product has no SKU and I fail to map it?
Here is the scenario:
- Create an order in Shopify.
- Select a product where the product SKU field is blank.
- Sync the order to Connex.
- Connex uses the product SKU from Shopify to match the Connex products table. Since the product has no SKU, Connex uses the SKU unknown.
- Connex fails to calculate total profit because product matches no product in Connex. Some reports in Connex are incorrect. If you use the Amazon dashboard, your percentages are wrong because your product has no cost of goods sold.
What if I fix the SKU in my selling channel?
Future sales will sync with the proper SKU. Previous sales, even if deleted and resynced, will have the blank SKU.
How do I map SKUs?
Map the SKU, delete and resync the sale. Here are the steps:
- Login to Connex Inventory Planner.
- Click products.
- Click the product mapping tab.
- Enter the product SKU in Connex Inventory Planner that matches the unknown SKU. (TO DO: Add screenshot)
- Delete all sales that have the unknown product SKU. (TO DO add screenshot)
- Click connections.
- Select your channel.
- Under order settings, resync the date range of the sale.