Excel to WooCommerce

  • I have some basic excel documents we have managed to extract from an exsiting site for my customer and need to add them to WooCommerce on the developement site we are creating for them, but have no idea where to start, any help would be grateful.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)

  • It’s a bit unclear what you are trying to do.

    Do you mean you have excel sheets with products that you need to import? Or are they data sheets that need to be added to each product page?

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi there ,

    I understand you’re looking to import Excel documents into your WooCommerce development site. Here’s a brief guide to help you through the process:

    1. First, you need to convert your Excel files to a CSV format. You can do this directly in Excel by going to ‘File > Save As’ and choosing ‘CSV (Comma delimited) (*.csv)’ as the file type.
    2. Once you have your CSV files, you can import them into WooCommerce. Navigate to your WordPress dashboard, then go to ‘WooCommerce > Products’.
    3. Click on ‘Import’ at the top. You will be directed to the import screen.
    4. Click on ‘Choose File’ and select the CSV file you want to import.
    5. Click on ‘Continue’. The Column Mapping screen will appear. Here, you can match the columns in your CSV file to the appropriate fields in WooCommerce.
    6. After mapping the columns, click on ‘Run the Importer’. Your products should now be imported into WooCommerce.

    Please remember to test a small batch of products first to ensure everything is working correctly.

    I hope this helps.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Excel to WooCommerce’ is closed to new replies.