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 try to start the importing of a CSV file, you might encounter an error saying "Cannot import new products when WarehouseQuantity is set to "Don't import". This issue often arises from column naming conventions or if you don't have a column with listings' quantity in your file.
Solution:
During CSV mapping, don't leave the field as "Don't Import", instead, map the CSV field WarehouseQuantity to the name of the column where you have listings' quantity in your file, or set the quantity column to "WarehouseQuantity" in your file so it can be auto-mapped.
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.