When selling on Walmart, one of the very first steps for every merchant is to list the products on this marketplace. To begin smoothly, this article provides an ultimate guide on how to import CSV files to Walmart, allowing you to start selling on Walmart faster.
There are many possible methods for listing products on Walmart. In this article, we will walk you through 2 reliable and comprehensive ways to bulk import items using a CSV file to Walmart, including:
- Method 1: Manually import CSV inventory files to Walmart
- Method 2: Automate CSV upload to Walmart using LitCommerce
Let’s find out!
Import CSV Files to Walmart Easily!
With LitCommerce, you can quickly bulk list and update products on Walmart using data from your CSV files, saving you time and effort on manual uploads.
How to Import CSV Files to Walmart Manually
The Walmart default tool allows you to upload single and bulk items. The process is not overly complicated, but it is essential to follow all the steps closely.
Here is how you can import the CSV file to your Walmart store and add items in bulk:
- Navigate to the Catalog in your Walmart Seller Center and select Items.
- Click on the Add Items button in the top right corner of the page.
- Select the Upload in bulk link under Add thousands of items using a spreadsheet. Please note that Walmart no longer supports CSV files; they accept only spreadsheets in any Excel format. So, you’ll need to convert your CSV file into an Excel format before uploading.
- Check your file before uploading. Ensure it includes the items’ GTIN, UPC, or ISBN, and make sure the file size does not exceed 5MB.
- Then, you can either drag and drop your file onto the browser window under Upload, or click the Browse link to select the file from your computer and upload your file to Walmart.
Once you’ve submitted your file, you can check the upload status in the Activity Feed within Seller Center. Updates may take up to 24 hours. Keep in mind that if any data errors are found during the upload, additional processing time may be needed.
On the other hand, Walmart sellers can use the Single Item Setup options to import individual items in Seller Center quickly by following these steps:
- From the Seller Center page, go to Product Catalog > Items, then click on Add Items.
- Under the Search the Walmart catalog heading, hover over the Create a new item link to access Item Create.
- In the Item Create tool, you will need to fill in all product information, including name, category, SKU, description, media, and much more.
- When you are finished filling in all product information, click the Submit Item.
That’s how you can upload a CSV file to the Walmart Seller Center. If you prefer not to reformat your file and want to automate the product upload process, let’s explore the second method on how to import CSV files to Walmart using LitCommerce.
5 Steps to an Automated Walmart CSV File Upload with LitCommerce
If you are looking for how to import CSV files to Walmart and upload products, LitCommerce offers the most comprehensive solution for Walmart and eCommerce sellers. With the LitCommerce tool, you can easily import products to the Walmart marketplace from your CSV files within 5 steps, which will be discussed below.
#Step 1: Create a LitCommerce account
Let’s start by creating a LitCommerce account to take advantage of the automated Walmart CSV import feature. To register, visit the LitCommerce sign-up page.
Fill in your Name, Email Address, and Password, then click Create Account. Alternatively, you can sign up using your existing Facebook or Google account for a faster process. By registering, you agree to LitCommerce’s Terms and Conditions and Privacy Policy.
#Step 2: Set up your Walmart CSV file on LitCommerce
In the LitCommerce app, if you wish to use your CSV file to upload products to Walmart, you might set the CSV file as your Main store. Below are detailed steps for you to follow:
1. Upload your CSV file to LitCommerce
First, you have two options for uploading your CSV file to Walmart through LitCommerce:
- Add CSV File: If your product CSV file is hosted on a server or cloud service, simply copy the link and paste it into LitCommerce.
- Add Google Sheet: If your file is stored as a CSV, upload it to Google Drive and open it in Google Sheets. This option allows LitCommerce to keep your Walmart products updated whenever changes are made to the file. Ensure the link is accessible when using this method.
Once you’ve uploaded your file, LitCommerce will direct you to the Import Settings page to enter the necessary details for your setup.
2. Configure your Walmart CSV import settings
Here, you’ll need to provide the following information:
- Store Name: Assign a name to your CSV store for easy reference.
- File Name: Name the file you’re uploading for better organization.
- Type of Import: Choose whether to add new products and update existing ones, or only update your current products on Walmart.
- Add New & Update: Use this option to add new products to Walmart and update existing ones.
- Update Only: Select this option if you only want to update existing Walmart products. Ensure the product ID remains the same to avoid errors.
- Import Method: If you’re using the Add CSV File option, you can select between URL download or FTP/SFTP. If you chose Add Google Sheet, skip this step.
- URL Link: Paste your accessible URL, where your CSV file is located, or the Google Sheet link here.
- Test Connection: If you are using a CSV URL or FTP/SFTP, click Test Connection to ensure that LitCommerce can access your product data.
3. Map your CSV fields to Walmart product attributes
After LitCommerce connects to your CSV file, you’ll be taken to the Attribute Mapping screen. Here, you’ll map the columns in your CSV file to the corresponding product attributes in Walmart. This step on how to import CSV files to Walmart ensures that your product data is imported correctly.
LitCommerce will automatically detect and match column names in your file to system attributes like SKU, Product Name, Price, and Quantity.
If some columns are not auto-mapped (e.g., due to slightly different column names), you can manually select the correct attribute from the dropdown. You can also uncheck any fields you don’t wish to import.
Once everything is mapped, click Save to begin importing your product data into Walmart via LitCommerce.
#Step 3: Connect with your Walmart store
Via the First Channel Setup page, choose Walmart to continue. You can also connect to other channels later.
Note: On the initial setup page, you can only connect your store to one sales channel. After finishing connecting, you can go back to the LitCommerce dashboard and create more channels as you want.
#Step 4: Bulk import and upload products to Walmart
Let’s move on to the next step: importing and updating your products to Walmart via your CSV file. Below are the guidelines for the two most common scenarios:
- You only want to update existing products on Walmart.
- You want to add new products and update existing products on your Walmart store.
Case 1: Import and update products on Walmart using a CSV file
This case might be the most basic and standard process when learning how to import CSV files to Walmart and bulk upload products. LitCommerce makes it easier in several steps.
If you’re looking to add new products or update existing listings on Walmart, follow these steps:
- From the Admin Dashboard, navigate to the left sidebar and select All Products.
- Next, select the checkbox next to the items you wish to list on Walmart.
- Click Select action and choose List products on a channel from the dropdown list.
- Choose Walmart and click Add As Draft Now.
- Finally, go to Walmart, select the products, click Select Action, and choose Update to Walmart.
Before publishing, you can customize your listings to meet your requirements. Click on any product to edit details like category, condition, shipping options, pricing, and return policy to ensure everything is aligned with Walmart’s standards. Once you’re satisfied, click Save & Publish to Walmart.
And that’s it! You’ve successfully imported and updated your products to Walmart using your CSV file.
Case 2: Bulk update existing products on the Walmart store
If you only need to update existing products on Walmart without adding new ones, the “Update Only” import method is your best option.
Here’s how to bulk update products on Walmart with your CSV files:
- Once your Walmart store is connected to LitCommerce, go to your Walmart tab and click Import from Walmart to bring in your existing Walmart listings to LitCommerce.
- Configure settings like auto-linking matching SKUs from your Walmart store and the CSV file, importing deleted items, and more. Once you’ve selected your preferred settings, click Begin Import.
- After importing, on your Walmart store on LitCommerce, select the products you want to update and click Create to All Products to add them to the All Products section. This helps link the product on Walmart with the one on your CSV files.
So, once your Walmart products appear in All Products, you can bulk edit the CSV file (e.g., adjust pricing, descriptions, or inventory). Any changes you make will automatically sync with Walmart, provided the product IDs match.
If you’ve set up a scheduled sync for your CSV file, LitCommerce will automatically update your Walmart listings at the scheduled time. This saves you from manual updates and ensures your listings are always up-to-date.
By following these steps, you’ve almost completed the steps on how to import CSV files to Walmart with LitCommerce. This automated process saves time and ensures that your product data is consistent across all platforms.
Easy CSV File Import with LitCommerce
What’s holding you back from choosing Walmart integration? Try the LitCommerce tool today and seamlessly list and sell products on Walmart from your CSV files now!
#Step 5: Enable inventory sync and price sync
Being able to sync inventory and price makes managing your Walmart store easier, especially when you are selling on multiple channels. Additionally, there are several benefits that Walmart sellers should take into consideration when discovering how to import CSV files to Walmart using LitCommerce.
To activate inventory and price sync for your Walmart store, click Channel settings on your Walmart store from your LitCommerce dashboard.
First, the Price Sync feature can update the prices of all listings on Walmart based on the data in your CSV file. As a result, by enabling this function, Walmart sellers do not need to go through all the steps to update the price of selling items.
Moreover, you can also activate the Inventory Sync feature. LitCommerce will automatically update the inventory quantity on Walmart based on the CSV file. In detail, the system will subtract the initial quantity in the CSV file from the number of items in the customers’ orders. Therefore, Walmart sellers will not need to manually update the stock quantity and avoid violating Walmart Marketplace’s Seller Performance Standards.
How to Import CSV Files to Walmart: FAQs
How to create a Walmart inventory CSV?
You can create a Walmart CSV file with the help of any spreadsheet program. Here is how you can simply install a CSV file from Google Sheets:
1. Open Google Sheets and input product information.
2. When you finish filling in data, go to File > Download > Comma Separated Values (.csv).
What is a Walmart CSV file?
A CSV (comma-separated values) file contains plain text values separated by commas. Regarding Walmart CSV, the data in the spreadsheet might include several pieces of information relating to the selling items on this marketplace.
For example, a typical eCommerce CSV looks like this, where each line contains the same sequence of data:
– Product, Size, Color, Price.
– T-Shirt, XL, Black, $10.
– Shirt, L, Pink, $17.
– Shorts, M, Khaki, $20.
How to import CSV files to Walmart?
Walmart no longer accepts CSV files, so you must convert your CSV file to Excel format if you want to upload it directly to Walmart. Alternatively, you can use a third-party tool like LitCommerce to import your CSV link to Walmart.
Here are 5 steps to upload a CSV file to Walmart and bulk upload products:
– Step 1: Create a LitCommerce account
– Step 2: Set up your Walmart CSV file on LitCommerce
– Step 3: Connect your Walmart store
– Step 4: Bulk import and upload products to Walmart
– Step 5: Enable inventory sync and price sync
Final Words
In short, importing products to Walmart might not be an easy task, and it will take hours to have your items appear on the marketplace. We hope that this multichannel selling guide on how to import CSV files to Walmart using LitCommerce will save sellers more time and effort. Don’t worry if you are a new seller, LitCommerce is an affordable solution, so you can explore the free plan and decide to upgrade later.
If you have further questions or need more information, don’t hesitate to contact us. In addition, you can explore our elite community to see more eCommerce tips and tricks.