In this section, you can bulk upload (import) your products into the system using an Excel (CSV) file, or export your existing products to download them to your computer.
This enables easy, large-scale product management without dealing with manual processes.

This method is especially useful for users who want to add or update product details such as price, stock, category, or description for multiple products at once.

18.1 – Exporting Products

This tool allows you to export your store’s product data as a CSV file.
By doing so, you can back up your product information, use it in other systems, or edit it in Excel for bulk updates.

To perform this process, follow the steps below:

1. From the admin panel, go to Products > All Products > Export.
2. In the form that appears, set the necessary filters for export:

3. After completing all selections, click the “Generate CSV” button at the bottom right of the screen. The system will create the CSV file based on your chosen criteria and automatically prompt you to download it.

Tip
If you want to back up all products, simply click the “Generate CSV” button without changing any filters.

18.2 – Import Products

This tool allows you to bulk add or update products using a CSV file. It’s especially useful when you need to upload a large number of products. You can bulk update stock levels, import products from another site, or make mass edits to existing ones.

In short, instead of adding hundreds of products one by one, you can upload them all at once with just a few clicks.


Step 1: Preparing and Downloading the Product File

Using the import tool for bulk product uploads or updates helps you save time. The preparation stage is crucial for a successful import process. Follow these steps:

• Export (Optional but Recommended): Download your existing products from the “Export” menu to get a reference CSV file.
  ➜ This file shows the column names expected by the system (e.g., Name, Regular Price, Stock, etc.).
  ➜ It also serves as a template to help ensure a smooth import process without errors.
• Edit in Excel: Make the necessary changes in the exported file — for example, add new products or update prices/stock levels.
• Save: Once your edits are complete, save the file on your computer in CSV format.

Step 2: Go to the Import Menu

• From the admin panel, click Products > Import in the left menu.
• On this page, under “Import Products from a CSV File,” the bulk upload tool will open.

Step 3: Select Your File

• Use the field “Choose a CSV file from your computer” to upload your product file.

👉 Maximum file size: 50 MB.
Once you select the file, the system will automatically verify the data.

Step 4: Update Existing Products (Optional)

• If you want to update products that already exist in your system, enable this option.
  • When enabled: Products with the same ID or SKU will be updated.
  • When disabled: Only new products will be added; existing ones remain unchanged.

This feature is useful for bulk updates such as prices, stock, or descriptions.

Tip
Always back up your products using the “Export” tool before making mass changes.

Step 5: Advanced Options

• At the bottom of the page, click “Show advanced options” to access detailed settings.
• Here, you can customize technical parameters such as the CSV delimiter, date format, etc.

In most cases, the default settings are compatible with Excel files, so there’s no need to change them.

Step 6: Continue

After selecting the file you want to upload and adjusting the update option if necessary, click the “Continue” button.


Step 7: Check the Column Mapping Screen

• On the next screen, the system will display the column mapping page. Here, you can see which columns in your CSV file correspond to which product fields in the system.
• The column headers in your CSV must match the product fields in the system.
• For example:
  • ID → ID
  • Regular Price → Regular Price
  • Stock → Stock
  • SKU → SKU
• If there are unnecessary columns, you can ignore them during the import process.

Step 8: Run the Importer and View Products

• Once you’ve confirmed that all columns are mapped correctly, click “Run the Importer” to start the import process.
• After the process is complete, click “View Products” to see your imported products.

⚠️ Important Notes

1. The file format must be CSV.
2. Column headers must exactly match the system’s field names. Using correct column names ensures data is imported into the right fields.
   For example, if your Excel column is named “ID”, the corresponding system field should also be “ID.”
   If there is no identical name, select the most accurate matching term.
   (Example: For the column “Product Stock Number”, select “SKU”.)

3. SKU (Stock Keeping Unit) must be unique. If the same SKU is used for multiple products, the system may overwrite or incorrectly update products.
4. When updating existing products, the file must include either the “ID” or “SKU” field. The system identifies existing products using these values. If neither is provided, the system treats them as new products.
5. Be careful with variable products. Each variation must have its own SKU value. If the relationship between the parent product and its variations is incorrect, the variations will not appear.
6. Always export and back up your products before importing. This allows you to easily restore your product list in case of errors.
7. Image files must already be uploaded to the Media Library. WooCommerce does not automatically fetch images — they must exist in your WordPress Media Library or have an accessible full URL.
8. The image URLs entered in the file must be complete and start with “https://”. Otherwise, the system won’t be able to find them. If using multiple images, separate each URL with a comma (,).