[WooCommerce] How do I bulk update Autoship data on specific WooCommerce products?

This doc covers how a merchant can update Autoship product data for specific WooCommerce products in bulk. To accomplish this, you will need the WooCommerce Product Importer & Exporter utility. This is one way to update products which allows for more control of which products are updated (for updating all products in bulk, the Autoship Cloud plugin offers Bulk Utilities to do this). 

In this article, we will review one way that merchants can be more selective about which products and variations are included when updates are needed to only specific products. 

What is the WooCommerce Product Importer & Exporter? 

The WooCommerce Product Importer & Exporter allows merchants to download their products to an easy to edit .csv file. Read more about the Product Importer & Exporter in the WooCommerce Product Importer & Exporter documentation.

WooCommerce Product Importer vs Autoship Bulk Utilities

Where the Autoship Cloud Bulk Utilities act on all products, the WooCommerce Product Importer makes it easier to update specific product data in bulk. This avoids having updates apply across all products and avoids having to edit the individual products in WP-Admin > Products one-by-one. All the updates made to the exported products will be automatically synchronized with QPilot upon the import's completion! 

When Should I Use the Product Importer

  • When merchants have a mix of products and where not all products are offered for Autoship
  • When using different product discounts for products
  • When tight control is needed on product availability in QPilot 

Below you will learn what the important Autoship product metadata fields are, and how to update these fields for specific products using the WooCommerce Product importer & Exporter utility.

How to Update Autoship Product Metadata Fields Using the WooCommerce Importer & Exporter?

Step 1: Enable Product for Autoship

We recommend Enabling Autoship on a couple products first, this way Autoship metadata columns will be included in the export automatically. Enabling one simple product and one variable product for Autoship will serve as a template for the values which can be referenced and copied for Autoship Cloud's supported product types. See our doc Enabling Products for Autoship for more details.

Step 2: Export Products from WooCommerce 

Go to  WP-Admin > Products and select "Export" 

  1. Select the (WooCommerce) columns to include in the export
  2. - Pro-tip: We recommended limiting the exported columns for increased performance in the export 
    1. What Columns are Recommended to Export?
      • Id - WC Product Id / Post Id for the product (Qpilot Product External Id)
      • Name - Product Title for the product, helps quickly identify the product
      • Type - Product Type can be used to filter our non-supported product types
      • Categories - Categories are another good way to identify products desired for autoship or not (for example a water company may not want to enable their “filtration_ systems” category for Autoship but want their” filter”, “salts”, etc. categories to be available)
      • Shipping Class - This will help identify any shipping classes attached to Autoship products so they may be removed if not needed or provide the shipping classes for which Autoship Cloud shipping rates must be created to support
      • Regular Price - Identifies the regular price which can be used to uniquely discount a product’s Autoship prices in the metadata 
  3. Select Product Types to include
    1. QPilot supports Simple, Variable, and Variation product types, filtering out others will help avoid unnecessary products from being exported 
  4. Select the "Yes, export all custom metadata" checkbox (this will make sure your Autoship metadata columns are added to the export
  5. Select "Generate CSV" button to export 

Step 3a: Recommended Minimum Autoship Product Metadata Values to Update

  • Meta:_autoship_sync_active_enabled
    • Set to 'yes' to activate Autoship product sync for the product 
    • Set to 'no' or an empty value to disable Autoship product sync for the product 
  • Meta _autoship_schedule_options_enabled
    • Set to 'yes' to display Autoship options on the product page in the store
    • Set to 'no' or a value so Autoship options are not displayed on the product page in the store
    • (Variable Products Only) This will enable Autoship options by default when set to 'yes' on 'Variable' product types. To disable Autoship options per 'Variation' see the 'Meta: _autoship_dissable_schedule_order_options' below.
  • Meta:_autoship_schedule_order_enabled
    • Set to 'yes' to allow customers to add the product to Scheduled Orders in My Account > Scheduled Orders
    • Set to 'no' or an empty value to disable the product from being added by customers to Scheduled Orders in My Account > Scheduled Orders
    • Set to 'yes' to enable the product to be available for processing on Scheduled Orders 
    • Set to 'no' or an empty value to disable the product from processing on Scheduled Orders 
  • Meta: _autoship_checkout_price
    • This is the checkout price for the product when selected for Autoship
    • Enter a number for the price (for example: '15' or '199.99')
  • Meta: _autoship_recurring_price
    • This is the recurring price (QPilot Sale Price) for the product when added to Scheduled Orders 
    • Enter a number for the price (for example: '15' or '199.99')
  • Meta: _autoship_dissable_schedule_order_options
    • This toggles the Autoship options displayed on variable product pages for particular variations - read more in Autoship Product Settings
    • Set to 'yes' to disable options for a particular 'Variation' 
    • Set to 'no' or an empty value will display Autoship options for the 'Variation'

There are additional Autoship product metadata fields added to WooCommerce products which may also be updated, see all these additional fields in our doc: Autoship Metadata Fields Added to WooCommerce Products

Step 3b: Update Export with Autoship Product Metadata Values

  1. Open the downloaded .csv file of your exported WooCommerce Products in a spreadsheet editor
  2. Update the Autoship columns with the desired values and save the file (as a .csv file)

See below for an example of how a merchant can update specific Autoship product metadata in the product export. The updates will synchronize with QPilot upon import of the updated product export!

Step 4: Import the Updated Product CSV

  1. Go to WP-Admin > Products and select the "Import" button
  2. Upload the updated .csv file from step 3a-b
  3. Select the checkbox "Existing products that match by ID or SKU will be updated. Products that do not exist will be skipped," then select "Continue" button (image below)
  4. On the "Map CSV fields to products" page, no changes are needed: no column labels / headers were updated on the export. 
  5. Select "Run the Import" button: your products will update in WooCommerce, then synchronize those updates to the imported products in QPilot.

Step 5: Review Imported Products in WooCommerce

Review the imported products in WooCommerce and confirm the updates to the products imported