¶ How to Import Products Via CSV
How to Import Products Via CSV
Adding products to your online store became easier with the option to import them in bulk using a CSV file. This guide will walk you through the steps to efficiently upload your products, saving you time and effort.
Prerequisites:
- Access to the Payments > Products page in LeadMagicX.
- A properly formatted CSV file containing your product details.
- A downloaded sample CSV file from LeadMagicX for reference.
¶ Steps to Import Products via CSV
1. Navigate to the Products Section
- Go to the Payments tab on the left and select Products at the top.
2. Initiate the Import Process
- Click on Import as CSV.
3. Upload Your CSV File
- You can either click to upload your CSV file or drag and drop it into the designated area.
Note: You can get a sample by clicking on Download Sample CSV to ensure each field matches the format in the sample file to avoid errors during import.
4. Prepare Your CSV File
- You can create a new CSV file following the sample format or edit the downloaded sample file.
Key Columns:
- Handle: The unique product ID.
- Title: The name of your product.
- Body: A description of your product.
- Images: Links to product images.
- Variants: Options for product variations (e.g., size, color).
- Current Price: The price for each variant.
- Comparison Price: The original price for each variant, if applicable.
CSV product import:
Store owners can bulk import products with more product details fields via CSV file. All the fields that can be imported via CSV are as follows:
Inventory variables:
- Track Inventory - True/ False
- Allow out-of-stock purchases -True/False
- Available quantity - number
- SKU
Shipping Variables:
- Weight value - number
- Weight unit - Kg, g, lb, Oz(Non-case sensitive)
- Dimension Length - number
- Dimension Width - number
- Dimension Height - number
- Dimension unit - cm, m, in (Non-case sensitive)
Product Label:
- Enable Product label - True/ False
- Product label content
- Start date and time - ISO Format
- End date and time - ISO Format
- SEO variables:
- SEO Title
- SEO Description
How to access:
- After finalizing the CSV file.
- Upload the CSV file by clicking “Click to Upload”
- Click the Upload & Preview button If errors are displayed, resolve them and upload again.
- Preview the first product in the list.
- After checking, click on Import products.
- A popup will appear indicating the import process.
- Once the import is completed, the products will be visible on the Products page.
By following these steps, you can streamline the process of adding multiple products to your store, making inventory management more efficient and less time-consuming.
Important Notes & Tips:
- Errors: If there are issues with your CSV file, an error message will appear, providing details on what needs to be corrected. Fix the errors and re-upload the file.
- Updating Existing Products: The same process can be used to update product details. Ensure the SKUs are consistent for smooth updates.
- Limitations: LeadMagicX may impose a maximum file size for CSV uploads. Be sure to check your file size before attempting to upload.
Troubleshooting Common Issues
**
**Here are some common issues users may face during bulk import:
- File Format Issues: Ensure the file is saved as a .csv and that all fields match the required format as per the sample file.
- Missing Required Fields: Verify that all mandatory fields (e.g., Product Name, SKU, Price) are filled in.
- Special Characters: Remove any special characters that could interfere with the import process.
Note: If you encounter any issues you can’t resolve, contact the LeadMagicX support team for further assistance!
¶ FAQs:
Question: How do I get a sample CSV file for importing products?**
**Answer: You can download a sample CSV file by clicking the “Download Sample CSV” button during the import process. This file will serve as a reference to ensure your product details are formatted correctly.
Question: Can I update existing products using the CSV import?**
**Answer: Yes, you can use the same process to update product details. Ensure that the SKUs remain consistent across the file so that the updates are applied correctly.
Question: What should I do if there is an error in my CSV file during the import?**
**Answer: If there are errors in the CSV file, an error message will appear with specific details. Fix the identified issues, and re-upload the corrected file to proceed.
Question: Is there a file size limit for CSV uploads?**
**Answer: Yes, there may be a file size limit for CSV uploads. Check the file size before uploading to ensure it meets LeadMagicX’s requirements.
Question: How can I ensure my CSV file is formatted correctly for import?**
**Answer: To ensure your CSV file is formatted correctly, download the sample CSV file from the “Download Sample CSV” button during the import process. This sample file will guide you in structuring your product details, ensuring all required fields are included and correctly formatted, which will help avoid errors during import.
Question: Who can I contact if I face issues I can’t resolve?**
**Answer: Contact the LeadMagicX support team for assistance with CSV import issues that cannot be resolved using the troubleshooting tips.
Question: Can I move files between different folders?
Answer: Absolutely. You can select one or multiple files and use the “Move to Folder” option. This is a great way to clean up your library if you have many loose images sitting in the main “root” directory.
Question: How do I handle product images in a CSV file?
Answer: You cannot “attach” a physical image file to a CSV. Instead, you must provide a direct, public URL for each image (e.g., https://yourdomain.com/image.jpg). The system will then visit those links and automatically download the images into your store during the import process.
Question: What should I check if my file is being rejected even though the data looks correct?
Answer: Ensure the file is saved specifically in .csv format and check for special characters in your text fields, as these can often interfere with the system’s ability to read the file.