How To Import Products From Computer To E-Store (PC Data Transfer Guide)

A PC data transfer moves product information from a spreadsheet on your computer into your online store in one upload. WooCommerce has an importer built in for exactly this, so a file of 500 products becomes 500 live listings without you typing any of them by hand.

The catch is that the importer reads your file literally. It creates whatever your spreadsheet says, which is why the preparation matters more than the upload itself.

In this article, we’ll cover why a PC data transfer is worth doing, how to run one step by step with the free built-in importer, which import settings actually matter, and what to check when a transfer doesn’t behave. So, let’s get right to it!

Table of Contents

Why Should You Perform A PC Data Transfer?

Moving product data from your computer in bulk saves hours and produces a more consistent catalog than manual entry does. Here are the five reasons it’s worth the setup time.

1. Efficiency

Entering product details one at a time is slow and easy to get wrong. Transferring a prepared file uploads hundreds of products at once, which leaves you free to spend the time on growing the business instead.

2. Accuracy

Importing from a prepared file cuts out the typos that come with repetitive data entry. Your listings match your source data, because they came from it directly rather than being retyped.

3. Consistency

One source file keeps your product listings uniform. Names, descriptions, prices, and categories all follow the same format, so you don’t end up with “T-Shirts” and “Tshirts” as separate categories.

4. Bulk updates

The same file works for changes later. Edit prices or stock levels in your spreadsheet, re-import it with the update option enabled, and every change applies at once. A bulk product upload is far quicker than editing products individually.

5. Backup

Keeping your catalog in a spreadsheet gives you a copy that lives outside your store. If something goes wrong on the platform, you have your product information ready to re-upload.

Want a worked example of moving a file’s contents into a store? See our guide on how to import data from CSVs.

Prepare Your File Before You Transfer

Save your spreadsheet as CSV UTF-8 with one product per row and a header row naming each column. CSV is the only format WooCommerce reads, so an XLSX or ODS file needs a Save As first, and the UTF-8 part is what keeps accented characters and currency symbols from arriving as garbled text.

Less is required than most guides suggest. Only a Name column is genuinely mandatory, plus Type for anything that isn’t a simple product. SKU is optional but worth including, because it’s how later updates find the right product.

• Quote any cell containing a comma, including multiple categories or image URLs in one field.
• Use > for nested categories, as in Clothing > Shirts.
• Use 1 and 0 for yes/no columns rather than “yes” and “no”.
• Strip currency symbols from prices, so 29.99 rather than $29.99.
• Remove empty rows and unmerge cells before exporting from your spreadsheet app.

How To Transfer Data From PC To Online Store

The whole transfer runs from Products → All Products → Import in your WordPress dashboard. Nothing needs installing first, because the product CSV importer ships with WooCommerce.

Step 1: Upload your import file

Go to Products → All Products and click Import. Choose the CSV from your computer and continue.

If the file is too big to upload through the browser, don’t fight the limit. Open Advanced options, move the file onto your server over FTP, and enter its path instead. The importer reads it directly and the upload cap stops applying.

Step 2: Map your columns

WooCommerce reads your header row and shows a Column Mapping screen with your columns on the left and its own fields on the right. Familiar headers like Name, SKU, and Regular price are matched automatically.

Your headers never needed to match WooCommerce’s names, which is worth knowing before you spend time renaming a supplier’s file. A column called “Item Code” maps to SKU from the dropdown just as well.

Read this screen properly rather than clicking through it. Anything WooCommerce doesn’t recognize defaults to Do not import and gets skipped silently, which is the single most common reason products arrive with fields missing.

Step 3: Run the transfer

Click Run the importer and WooCommerce processes the file row by row, showing progress as it goes. Large catalogs take a few minutes, especially when rows carry image URLs that need downloading.

When it finishes you get a summary of how many products were imported, updated, skipped, and failed. Open three to five of the new products and check the frontend before you trust that number, because a “successful” run can still have skipped rows.

Import Options That Matter

Two settings decide how the import behaves, and both sit on the upload screen before you get to mapping. Getting them right is the difference between a clean catalog and a duplicated one.

• Update existing products. Leave it unticked and only new products are created, with matching rows skipped. Tick it and WooCommerce matches each row by product ID or SKU and updates that product in place. This is the setting that prevents every product appearing twice.
• Advanced options. This is where you supply a server file path instead of a browser upload, and where you can change the CSV delimiter if your file uses semicolons rather than commas, which is common on European systems.

A few column-level behaviors are worth knowing before you run a transfer:

• Images come in by URL. The first URL in the Images column becomes the featured image and the rest become the gallery, so long as each one is publicly reachable.
• Custom fields transfer by prefixing the column header with meta:, so meta:supplier_code lands in a supplier_code field.
• Keep the file narrow on an update, including the match columns plus the fields you actually intend to change and leaving the rest out of the file.

When A PC Data Transfer Does Not Work

Most failed transfers come down to four causes, and checking them in this order finds the problem fastest.

• Garbled characters: the file wasn’t saved as UTF-8. Re-save and run it again.
• Missing data on imported products: those columns were left on “Do not import” during mapping.
• Every product duplicated: Update existing products was left unticked.
• The import stalls partway: a server timeout. Split the file into batches of 500 to 1,000 rows.

For the longer diagnostic list, see our product import troubleshooting guide.

Conclusion: PC Data Transfer Accomplished!

Moving a catalog across is mostly preparation. Once the spreadsheet is clean and saved correctly, the upload itself takes a couple of clicks and the built-in importer does the rest at no cost.

Here’s a quick recap of what we covered:

• Save the file as CSV UTF-8 with one product per row.
• Upload it, or use a server file path when it’s too large.
• Check the Column Mapping screen instead of clicking past it.
• Set Update existing products deliberately, since it decides duplicates.
• Spot-check the results rather than trusting the summary.

If you’re planning a PC data transfer for a catalog you already have online, start from your real data. Export your products with Store Exporter Deluxe, edit the file on your computer, and send it back through the steps above.

Frequently Asked Questions

What is a PC data transfer for an online store?

A PC data transfer moves product information from a file on your computer into your store in one upload, rather than adding products one at a time. In WooCommerce it means importing a CSV through Products → All Products → Import, which creates or updates every product in the file at once.

Do I need a plugin to transfer products from my computer?

No, WooCommerce includes a product CSV importer at Products → All Products → Import, and it handles simple products, variable products, categories, images from URLs, and custom fields. A paid plugin only helps if you need scheduled imports or feeds pulled automatically from a URL or FTP server.

What file format do I need for a PC data transfer?

CSV saved in UTF-8 encoding. XLSX, ODS, XML, and JSON files all have to be converted to CSV first, which every spreadsheet application does through Save As or Download. Choosing the UTF-8 variant matters, because plain CSV corrupts accented characters and currency symbols.

My file is too large to upload. What now?

Move the file onto your server over FTP and enter its path under Advanced options on the import screen. That skips the browser upload limit entirely. Splitting the file into batches of 500 to 1,000 rows works too, and has the advantage that a failure only costs you one batch.

Can I update products I already have instead of adding new ones?

Yes, tick Update existing products on the upload screen and WooCommerce matches each row by product ID or SKU, updating those products in place. Rows with no match are skipped rather than added, so keep your SKU column stable between runs.