• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Essential Premium WooCommerce Plugins - WP Desk
  • Plugins
  • Bundle
  • Support
  • Blog
  • My Account
  • 0

Stay updated on our how-to articles

WP Desk news, WooCommerce tips, promo codes - right to your inbox.

By entering your e-mail, you agree to our Terms & Conditions and Privacy Policy.

Monika Kwiatkowska

Use two XML files to import products in your WooCommerce (dropshipping)

Updated: January 21, 2022 / Plugin Tutorials, Tech Posts

You have a dropshipping store. Import products is easy because you use Dropshipping XML WooCommerce plugin. Everything is fine, and your sales are constantly growing. One day you get a message that the wholesaler gives you two files: one with all product details and the second with stock availability. Is it possible to import products from two different files?

Positive sites of using two XML files

Yes, the Dropshipping XML WooCommerce plugin can handle this scenario! Then there's at least one advantage of using two XML files, and this is a possibility to improve import speed. File with only stock availability is light and can significantly reduce WordPress memory and server process usage.

Dropshipping XML WooCommerce £79

Import and synchronize wholesale products with WooCommerce products.

Add to cart or View Details
WP Desk
Plugins used by 235,543+ shops
Last Updated: 2023-03-20
Works with WooCommerce 7.2 - 7.5.x
You may import products from two XML files also with the free version of the plugin!

How to import products to a WooCommerce store from two files?

First, I will use a file with details as the product's name, description, price, pictures, all that is required to create a WooCommerce product. Now I prepare my files for importing. This step is crucial; I have to find precisely the same tag in both files. These tags are essential to identify products. Sometimes it will be a name, sometimes the ID of a product.

I will use the ID product tag because my file with stock availability doesn't contain a product name tag. So I will use ID for mapping the SKU field in the WooCommerce product. Using the same field to identify products is necessary for the proper import process. Otherwise, update stocks of existing products is never going to happen. Those Field SKUs will allow to recognize product in a shop and update it.

Then I chose a field for mapping in the first file. Drag and drop tags from the file to fields related to the product's name, images, description, price, and size. Also, I choose a tag for representing SKU, and it is ID.

drag and drop tags

I configure the fields for mapping and go to the configuration options. I choose the field identifying the product in the store. It will also be used during the second import so that the products in both files have the same field and can be recognized.

field to identifying products

In this step, you can choose fields based on the plugin that will synchronize the products from the file with the existing products in WooCommerce. You can ask your wholesaler about the frequency of the updates of price, description, etc.. Based on this information, you can set up a schedule of imports.

synchronize products fields

Next, you can start the import. After the end of the process, you should see all products from the file in your shop.

import products dropshipping in WooCommerce

XML file with stock availability

Ok, the second step! It's time for a second file with stock availability. All process is similar to work with the first file:

import products step one

If you need to import files from FTP or upload them directly from your computer, use the FTP Import for Dropshipping XML WooCommerce add-on.

In a second step, I choose the same parameter for mapping the SKU field as in the first file. I select the option Import into products on the basis of an ad tag related to stock availability.

mapping fields xml file

Look at the XML file with stock available. It contains fewer tags than the first one. So the most important thing now is choosing the same tag for identifying the product!

At the last step of import, I am configuring import options. I choose that the product is recognized with SKU. Also, I select the checkbox Don't create, only update existing products because, in my scenario, I don’t want to create new products but just update them.

last step of import product

The last thing to do for this step is to select the synchronization frequency, i.e., periodically updating products in your store. In this case, all are on the side of wholesale, which delivery XML file with products. Contact with and based on this choose date and hours of starting the import process.

How to check that the process is proceeding correctly?

During the import, you can see the information. A product has been found and will be updated. It's a sign that everything goes well and products are recognized and located in the file and the shop.

import log window

If you choose incorrect fields for product identification in the files, the following message will be displayed in the import log: Product not found. In this case, check that you have used the correct tag in the SKU field and that you have correctly selected the parameter in the Import into products on basis of.

product not found

After the import is completed, the number of items available in the store shall be updated.

updated products

Documentation & Video Tutorials

Visit the plugin documentation to see and read about all its options. Also, watch the videos in the playlist below to see how to import & update products in WooCommerce.

 

Product synchronization from two XML files in your WooCommerce store

I hope that my article clearly explains how to use two XML files at the same time. You can try for yourself Dropshipping XML WooCommerce with our demo. You can test our plugin with your product file. If you encounter any difficulties while configuring the import or your files are atypical, please write to us. We will be happy to help!

Ask before buy →

Visit the product page to learn more & see all functionalities of the plugin.

Dropshipping XML WooCommerce £79

Import and synchronize wholesale products with WooCommerce products.

Add to cart or View Details
WP Desk
Plugins used by 235,543+ shops
Last Updated: 2023-03-20
Works with WooCommerce 7.2 - 7.5.x
Tweet

3 minutes read2000 views

Monika Kwiatkowska

Quality Engineer and Scrum Master in WpDesk Heroes Team. Huge fan of books, bikes, and board games.

Powered by WP Desk

WP Desk brings you great WooCommerce plugins. We strive to save your time and money by speeding up your processes. Use our plugins to build a better store. Awesome support included in the package.

Premium WooCommerce Plugins →

Stay updated on our how-to articles

WP Desk news, WooCommerce tips, promo codes - right to your inbox.

By entering your e-mail, you agree to our Terms & Conditions and Privacy Policy.

WP Desk › Plugin Tutorials › Use two XML files to import products in your WooCommerce (dropshipping)

Footer

WP Desk - WooCommerce Plugins

At WP Desk we create great WooCommerce plugins with awesome support. Save time and money with our e-commerce solutions. See how we can help you improve your e-store →

Secured by Comodo

WP Desk

  • About us
  • Giving Back
  • Blog
  • Contact us

Products

  • Premium Plugins
  • Get Support
  • WooCommerce Invoices
  • Email Marketing
  • Octolize

Legal

  • Terms & Conditions
  • Refund Policy
  • Support Policy
  • Privacy Policy

© 2023 WP Desk