- Knowledge Base
- Specs
- Import
-
Getting Help
-
12.3 Specific changes
-
Installation
-
Learn
- Business Activities
- Business Activity Manager
- Business Alerts
- Configuration
- Customer
- Database
- EDI
- General
- Inventory
- Manager Windows
- Mobile
- Picklists (Advanced Picking)
- Product
- Purchasing
- Purchase Order Manager
- QuickBooks & Acctivate Basics
- QuickBooks Desktop Sync
- QuickBooks Online Sync
- Reporting
- Sales
- Sales Order Manager
- Sales Tax
- Server
- Shipping
- Startup
- User Interface
- Webstore
-
Troubleshoot
-
Specs
-
FAQs
Importing in Alternate Product ID's
Users can add multiple alternate product IDs to a given product. This will allow for more detailed reporting as well as enable you to have webstore specific IDs.
Import Alternate Product IDs
To import in Alternate Product ID's, first create an Excel spreadsheet with your column headings for each field name you wish to import. Using Import Data, map the file location for your spreadsheet to the Filename, choose the correct worksheet if you have multiple sheets in your Excel file, name your import, then use the Columns tab in order to map each Column to its corresponding field.
In order to import Alternate Product IDs, go to File > Import Data > Product Alt IDs.
- Required Fields:
- Product ID
- Alternate Product ID
- Optional Fields
- Type (Alt, UPC, Web)
- Assigned By (Webstore Template ID)
For a general guide on importing in data, please check out our docs page.
Please refer to this table for our alt product ID mapping specifications.