Welcome to the Community, GG60. I'm here to assist you with importing your inventory.
In order to have a smooth experience with importing your inventory, it's important to ensure that your file format is correct. Please know that there are character limits that you need to consider.
If you're using the new batch import to import your spreadsheet, check the following formatting tips:
- Avoid special characters.
- Character limits:
- Product, variant, and category name: 512
- Option name, option value: 100
- Descriptions: 4000
- SKU: 100
- Quantity as-of Date: Format like this: MM/DD/YYYY
- Income and Expense account: You can't use subaccounts.
- Category: [Name of category]:[Name of sub-category] up to four levels.
- Example - Clothing:Jackets or Clothing:Shirts
- Variants: Add one line for each variant. When creating variants, make sure the product name and categories exactly match with the parent product. Be sure no variants within a product have the same combination of option values.
If you're using the old batch import method, take note of these formatting tips:
- Product/Service Name: 100 character limit. Avoid special characters. See the approved characters list for more info.
- Income Account: You can't use subaccounts.
- Quantity as-of Date: Format like this: MM/DD/YYYY or DD/MM/YYYY
- Income and Expense account: You can't use subaccounts.
Additionally, the maximum number of rows that can be imported at a time is 150. If your list is longer than that, it's best to divide it into multiple smaller files.
For more details on importing your inventory, you can refer to these articles:
In the future, you can refer to the resources from this material for more tips on tracking inventories in our system: Set up and track your inventory in QuickBooks Online.
If you have any other questions when importing your inventory in QuickBooks, feel free to ask in the comments below. I'm here to assist you, GG60. Have a great day!
