A supplier's product list imported as drafts
Turn a supplier's CSV into WooCommerce products, every one a draft, after a dry run that shows what would be created and what skipped.
- Difficulty
- Advanced
- Time
- about 30 min
Here is my supplier's product list: [paste the CSV or attach the file]. In it, [supplier column] is the SKU, [column] the name and [column] the wholesale price. Set the regular price to [wholesale price × 1.8, ending in .90], put the products in [category] and take the stock from the file. First do a dry run and show me what would be created, what would be skipped and why. After I agree, import them as drafts and tell me when the import has finished. Don't publish anything.
Already connected?
If SAR is already in your AI app, this is enough:
Import this supplier CSV as drafts in [category] at [markup]; dry run first.
What happens
- The AI app reads your categories, matches the supplier's columns to WooCommerce's and works out your prices.
- A dry run shows what would be created and what would be skipped. A SKU already in your shop is never changed.
- Once you agree, every product is created as a draft, so nothing visitors see changes. Large files continue in the background.
- You check the drafts. Each goes on sale only with your approval in SAR, and undoing the import deletes the drafts.
Approvals involved
Worked out from the tools this recipe uses.
wordpress_woo_list_categoriesProduct categoriesNonewordpress_woo_import_productsImport products from CSVNonewordpress_woo_import_statusProduct import progressNonewordpress_woo_list_productsList productsNonewordpress_woo_publish_productPublish a productApproval
What you get
Your supplier's range in your shop as drafts with your prices, ready to check and put on sale in batches.
Related recipes
- Shop · about 20 minA weekend sale on one category, with the 30-day lowest price shownPut a category on sale in one change you approve once, check the price shown before the discount and show the 30-day lowest price.
- Shop · about 15 minA new product from the photos on your phoneUpload your own photos through one-time links and get a simple product as a draft, with its price, stock, category and images in place.
- Shop · about 15 minA similar product made from one you already sellCopy an existing product with its variations as a draft, change what differs, and put it on sale after you have checked it.
Try it on your own site
Install the plugin, add SAR to your AI app and paste the prompt. Free to start.