Woocommerce is becoming one of the main e-commerce tools. It increasingly supports stores with a multitude of products, so it will be easy to find ourselves with the problem of uploading hundreds of products at once. For this problem, we want to talk to you about a plugin and its free and premium versions.
WP All Import for WordPress
WP All Import is the best plugin to import more complex content to WordPress. That’s why it’s the best option to upload large amounts of products to WooCommerce in seconds. We have 2 plugin options, the free one and the premium one. For many options the free one will be enough, but if we have products with variables, custom fields or upload images directly, the premium version will be necessary.
WP All Import for Woocommerce
In addition to WP All Import you will need a plugin or extension (you can download the free version from wordpress plugins). With this module you will be able to access the woocommerce product template to import each item to its correct location.
Prepare the product file to import into woocommerce
The first thing to do is prepare the file. WP all import supports Excel files, but we recommend converting it to comma-separated CSV first to avoid any incompatibility issues.
The document is very simple, each product will go in each row and in the columns we will put the fields that we need. For example:
ID
Product name
SKU: We advise you to add it to better identify the products
Short Description
Long Description
Inventory
Regular price
Offer price
Images
Weight
Width
Length
Colors / Sizes (this for variable products)
Categories
Tags
Yoast Title
Cross-selling
Upload images in bulk for each product
o upload images we have several options: One is to upload them to a server and put the URLs of the images in the images column (from the previous section) separated by commas.
Successful telemarketing requires certain key skills that determine a telemarketer’s effectiveness and success. First, communication skills are very important. A telemarketer db to data needs to know how to speak clearly and listen carefully to the customer. If you are looking for a secure database then you are talking to the right place. You can find more details on our DB to DATA website. Here you will get to know each page better by traveling. We provide you maximum data package at affordable price. So contact quickly.
Another option is to upload them to WordPress first. This is more tedious when dealing with many images, but it will take a second to link them later.
Once uploaded to WordPress, you can put them in the Images column, separated by commas, that correspond to a specific product:
Make sure you know where they are uploaded and put their address directly. You don’t need to put the domain at the beginning if they are hosted in the same place you are working.
How to import simple products to woocommerce
You select New Items (you can also update existing items) and indicate that they will be Woocommerce Products.
You will see all the registered rows and columns at a glance, accept and continue to the next step.
Step 2 : Now comes the fun part. On the left awb directory side of the screen it will look like you are editing a woocommerce product and on the right side, you will see the name of the fields. You will just have to click on the name of the field (in green) and drag it to the corresponding field:
Step 3 : Once you have filled out everything, simply click continue and finish the process. In a matter of seconds, we can have thousands of products in our woocommerce.
How to import products with variables to woocommerce
These are more complex products. To upload products with variables such as sizes, colors or models for the same product, we will need the pro version of WP all import for WooCommerce.
Preparing the document to upload variable products
Before importing the file, we need to prepare it for each variable. As you can see, WP all import gives us several options, the one I recommend is that you put a row with all the product data as if it were simple, but add a column (or as many as necessary) for the variables, for example Sizes or Colors. Then you create as many rows under the product as there are sizes and in each one you fill in the same name as the parent product (it has to be exactly the same) and put the size, price and inventory for each additional row. Example:
In this example we have 2 variations: Weight and Quantity. We could even add images for each variation, so that if the visitor chooses “9 oz” another image will appear.
Upload variable products to woocommerce in bulk
Now we upload the document as in the simple products section. But when we get to the product configuration section we select “Variable product”
Now we go to the Attributes section, give the attribute a name whatsapp number material and drag the corresponding column to the list of values.
Finally, go to Variations and choose the corresponding upload option. If we have prepared the document as explained above, this will be the option to choose. We put the name of the product in the corresponding field (it is important that the variations have the same product title).
Although you can upload both simple and variable products at the same time, I prefer to do different uploads to avoid configuration problems. This way I upload all the simple products first and then the variable ones. It will take you an extra minute, but there will certainly be less chance of error.
