Woocommerce – Product Spreadsheet with Attributes

When importing a large number of products, we use a spreadsheet to create and manage each product and their respective metadata. If products have variations, then we need to add each product multiple times and their respective variation.

In this video, I go through how to add attributes to your spreadsheet.

WooCommerce Product Spreadsheet Template: https://gxweb.site/ecommgooglesheet

Posted in ,

Christina Hawkins

Since 1999, Christina has been designing and building exceptional websites. With many years of experience in creating thousands of websites, she understands the need for continuing education in her field and, therefore, is constantly learning and teaching others about internet marketing and digital processes. Christina has honed her digital marketing and graphic design skills so that she can help B2B industries get their message out to their target audience in the right way. In addition to her ability as a digital marketer, Christina serves as a coach and mentor with WPElevation to other digital marketing freelancers, helping them grow their businesses. She is a sponsor and co-leader of Houston's WordPress Meetup. Recently, she spear-headed the next Houston WordCamp 2020 as its coordinator after a 10 year hiatus and became the Houston Interactive Marketing Association Director of Technology.

4 Comments

  1. Avery Thompson on November 23, 2017 at 12:35 am

    Thanks for the information Christina! I’m still pretty new to WooCommerce, and this is going to help me out quite a bit!! Thanks again for the insight

    • Christina Hawkins on November 26, 2017 at 2:19 pm

      You are most welcome, Avery.

  2. Toby on June 23, 2020 at 12:33 am

    Why do make the SKU the same for different lines? How do you have a unique identifier for BIN locations? Surely each product would have a unique SKU so that you can track your inventory and sales properly?

    • Christina Hawkins on June 24, 2020 at 3:53 pm

      You are right, Toby. Each product and each variation of a product needs to have its own SKU. Usually, though, in the spreadsheet, each line has its own SKU, then we add more numbers/letters for each variation.

Leave a Comment