Skip to main content

All Import

This documentation provides guidance on importing products to Globber's website, featuring a demonstrated example focused on pricing.

How to Import Product Pricing​

To learn how to export a file before importing, see the Export guide here.

In WordPress, Navigate to All Import on the left-hand menu in WordPress and select New Import

NavigateNewImport

Select Upload a file to attach your relevant CSV file.

AttachImportFile

When upload is complete, select Existing Items under "Import data from this import file into..", and also select WooCommerce Products underneath before you proceed to Step 2.

ImportExistingItems

Once that is done, you can proceed to Step 2 by clicking Continue to Step 2.

Step 2 displays all the data that are found inside the CSV, click Continue to Step 3 to import configuration.

ImportDisplayStep2

In Step 3, navigate straight to WooCommerce Add-On tab as this is the only focus for this example when it comes to importing new product prices.

WooCommerceAddOnImport

In WooCommerce Add-On, click and drag sku, regularprice and saleprice into their respective fields under WooCommerce Add-On. Once you've dragged them it'll automatically display each of the fields with different brackets.

  • SKU: {sku[1]}
  • Regular Price: {regularprice[1]}
  • Sale Price: {saleprice[1]}

WooCommerceClick&Drag

After click and dragging the above fields, proceed to Step 4 with Continue to Step 4 at the bottom of this page.

ImportProceedStep4

In Step 4, you will need to ensure your import file will only prioritise the fields you want to edit.

To avoid breaking other products & files in the website, select Post ID under "Records in this import file will be matched with.."

Step4Import1

In Post ID, click & drag id field from the right-hand side of import page.

Step4Import2

Under "For each record in this import file..", deselect Update all data and select Choose which data to update, afterwards select Unselect All to ensure that the file won't affect other parts of the website.

Step4Import3

In the same section, select Custom fields, Update only these Custom Fields, leave the rest alone and input "_price", "_regular price" and "_sale price".

Step4Import4

Proceed to continue to the next step.

Click Confirm & Run Import to initiate the final step.

FinalImportStep

Import progress will also be displayed in real-time.

ImportProgressBar

Once import is complete without any issues, you will be shown this screen, where you can go and see the product pages to see your changes.

ImportComplete

Go to your relevant product page with the adjusted price to see the result.

TestProductPricingDisplay