Menu Close
    Hire us Request quote Reading list Switch to dark mode

    Guide to Upload Products via CSV: Multi-Vendor Marketplace for Shopify-

    Multi-vendor Marketplace app for Shopify provides an ultimate solution for the e-Commerce merchants to convert their stores into fully-fledged marketplaces.

    Despite the fact that Shopify is one of the simplest platforms to start an online business, you have to deal with bulk product upload, add multiple sellers at a time, sellers requesting for the option to add products in bulk if you run an online marketplace. So, to have a simplified process, this guide will help you to understand how to upload the CSV files in the app and avoid errors.

    The Multi-vendor Marketplace app facilitates:-
    Admin to add products in bulk via CSV.
    Seller to add products via CSV.
    Admin adding sellers via CSV.

    In the app, admin can allow sellers to add products in bulk via CSV. For this, the admin needs to follow the below-given steps:-

    Go to the Product Configuration menu >>Enable Add Product by CSV tab.

    Product Configuration
    Admin Panel: Product Configuration

    As soon as the admin configures the details, the option to add products via CSV gets reflected at the respective seller panels.

    Add product by CSV
    Seller Panel: Products

    Now, the seller will click the Add Product by CSV button & choose the methods using which he/she wants to upload products in bulk.

    Upload CSV file

    Seller will get the instruction file in the app.

    Common mistakes that throw errors while uploading the CSV file and Solutions to avoid them

    While uploading a CSV file, vendors generally do some common mistakes that need to be taken care of. For this, the instruction file is provided in the app. The sellers need to follow certain instructions and avoid such errors in the CSV file upload.

    Mistake 1: UTF-8 Not Encoded!

    You may get unwanted special characters as errors if your CSV file is not UTF-8 encoded. So, you need to confirm the UTF-8 encoding before you save any CSV file.

    Solution


    CSV file must include UTF 8 encoding to avoid the unwanted generation of special characters in the CSV file.

    Mistake 2: Use of Local Path Images!

    The image field must contain the URLs of the product Images if the seller is using Method 2 to upload the products in bulk.

    If the seller will use the local path images in the CSV file, it throws an error as shown in the below screenshot:

    CSV file error
    CSV File Error

    Solution

    Convert your Local Path Image into URL and then, add the Image link to the required field.

    To convert your local path image into Image URL, you can follow the below-given path & easily convert it to a Link:-

    -Sign up/Log in to Drop-box.
    -On the Home page, click the Upload files button.
    -Choose a file or folder from your system & upload it.
    -Now, click the “Eye” button to get the Image URL.

    Dropbox
    Dropbox

    This way, you can convert your local images to a URL & use the same in the Product CSV files.

    In the case of multiple images, you can use the comma as a separator in the product CSV file.

    NOTE:- Images should be publically accessible.

    Mistake 3: No Default title value in case of No Variant!

    This is also a common mistake done by the sellers while uploading the Product CSV file. So, in case the product has no variant, make sure that you are using a default title value in the product CSV file.

    Solution

    For products with no variants, the option value should be set to “Default Title”.

    Make sure that sellers have added the option value as “Default Title” if any product has no variant.

    Mistake 4: Mismatch of Columns in CSV file

    Sometimes, admin upload the exact product CSV file downloaded from the Shopify store. This contradicts the instructions provided in the app and resulting in the column mismatch.

    Mismatch of the number of attributes with the number of columns will throw errors while validating the CSV file.

    Solution

    The number of attributes must match with the number of columns in the CSV file.

    The most suitable option is to:-
    download
    the sample CSV file from the app.
    edit the file as per the requirement.
    validate the updated CSV file.
    upload the same in the app.

    Mistake 5: Unrecognizable Character

    Sometimes, sellers get an error as “Validation Failed” while uploading product CSV file. This may happen due to unrecognizable characters used in the CSV file.

    Solution: Make sure that the characters used in the CSV file must contain a defined value.

    Mistake 6: Additional Columns

    Adding additional columns in the product CSV results in the column mismatch issue. This is the reason we suggest you download the sample CSV & make the changes in the existing file as per your requirements to avoid column mismatch issues.

    Seller Panel-Product Upload
    Seller Panel-Upload Product in Bulk

    Solution

    Make sure that the required fields in the CSV file cannot be empty.

    Conclusion

    Ultimately, you need to keep these points in mind to validate & upload the CSV file successfully in the Multi-vendor Marketplace app.

    POINTS TO BE NOTED:-

    -Firstly, always try to download the Product CSV file from the app, modify it as per your requirement and then, validate & upload the same in the app.

    Suggestion:- Avoid uploading the exact CSV file downloaded from your Shopify store.

    -The image URLs used in the CSV file should be publically accessible.

    -Check the columns & fields in the CSV files in case you have restricted product tags, product types & collections in the app.

    -Modify your CSV file once you add any custom fields in the app.

    In Short
    Keep updating Your Product CSV file in the app even if you make a small change in the Product Configuration.

    Learn to make the use of CSV files for Bulk Upload

    Still, you need any assistance, feel free to CONTACT US.

    . . .

    Comment

    Add Your Comment

    Be the first to comment.

    Back to Top
    css.php
    Hire Us!
    Brief us about your requirements and we'll get back to you.
    Woo! Hooy!
    We have just received your message and our expert will get back to you shortly.
    Send Again
    Close

    Table of Content

    Hide Index