How to Troubleshoot Common Issues with CSV Files on 3Dsellers
When managing listings on 3Dsellers, especially through CSV imports or external platform synchronization (such as eBay), users may encounter specific issues. This article provides solutions and preventative tips for the most common challenges, ensuring that your workflow remains uninterrupted.
Common CSV Import Errors and How to Fix Them
1. Error Related to 'Card Condition' Column
When importing a CSV file into the 3Dsellers draft page, you might encounter an error even after adding the required 'Card Condition' column as specified in the error report. This issue often arises from column naming conventions.
Solution:
Rename the column header to "C:Card Condition" instead of just "Card Condition" in your CSV file.
Retry importing the CSV file, as this adjustment usually resolves the error related to naming requirements.
2. Error Related to missing 'WarehouseQuantity' Column
When starting a CSV import, you may encounter the following error:
"Cannot import new products when WarehouseQuantity is set to 'Don't import'."
This usually happens when:
Your CSV file does not contain a quantity column, or
The quantity column was not mapped correctly during the CSV mapping step.
Solution
During the CSV mapping process, make sure the WarehouseQuantity field is not set to "Don't Import".
Instead, you should either:
Map
WarehouseQuantityto the column in your CSV file that contains the product quantity values, orRename your quantity column in the CSV file to
WarehouseQuantityso it can be mapped automatically.
Important: A quantity column is mandatory when importing new products into the catalog.
If you do not want to set actual inventory quantities yet, you can still import the products by setting the quantity value to 0 for all items in the CSV file.
Preventative Tips for Smooth Operations
To avoid these issues in the future, consider the following best practices:
Verify CSV Formats: Always double-check your file headers and formats to match platform-specific requirements. You can find more details about CSV required format and a CSV sample here.
Monitor Account Status: Ensure your eBay or external accounts remain active to avoid interruptions in listing synchronization.
Test Small Batches: Before uploading large CSV files, test with smaller batches to identify any errors early.
Backup Data: Keep a backup of your original images and CSV files for quick re-upload if something goes wrong.
By following these steps and solutions, you can minimize disruptions and ensure a seamless experience with 3Dsellers’ CSV Uploads.