Bulk Updating Woocommerce Product Data

%3CLINGO-SUB%20id%3D%22lingo-sub-2375538%22%20slang%3D%22en-US%22%3EBulk%20Updating%20Woocommerce%20Product%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375538%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20building%20a%20digital%20download%20photo%20website%20and%20have%20downloaded%20the%20wc-product%22%20CSV%20UTF-8%20database%20as%20a%20CSV%20files%20from%20my%20WooCommerce%20%22Products%22%26gt%3B%22Downloadable%20section.%20Instead%20of%20entering%20thousands%20of%20image%20file%20names%20and%20their%20image%20download%20URL's%20one%20by%20one%2C%20I%20intend%20to%20use%20the%20import%2Fexport%20tool%20within%20WooCommerce%20to%20add%20the%20filenames%20and%20corresponding%20URL's%20in%20bulk.%20While%20I%20do%20have%202%20product%20categories%2C%20the%20one%20I'm%20working%20on%20presently%20is%20%22Vintage%20Football%20Photos%22%20-%20column%20%22D%22%20on%20the%20worksheet.%20I%20noted%20that%20each%20record%20for%20the%20images%20added%20for%20the%20downloadable%20product%20contains%20the%20%22Download%20name%22%20and%20the%20Download%20URL%20for%20each%20image%20and%20is%20numbered%20consecutively%20that%20is%20to%20say%2C%20Download%201%20name%2C%20Download%202%20URL%20and%20so%20on%20across%20the%20worksheet%20(colored%20fields%20beginning%20with%20%22AU').%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20creating%20the%20CSV%20for%20uploading%2Fupdating%20the%20downloadable%20products%2C%20what%20should%20I%20name%20the%20columns%20for%20the%20new%20items%2Fdata%20I'm%20adding%20and%20updating%3F%20When%20updating%20will%20the%26nbsp%3B%20%22wc-products%22%20CSV%20or%20database%20automatically%20add%20the%20new%20records%2C%20numbering%20them%20sequentially%20as%20is%20the%20exported%20source%20file%3F%20The%20feature%20in%20WooCommerce%20allows%20me%20to%20bulk%20update%20using%20a%20CSV%20file%20and%20specify%20which%20fields%20to%20import%2Fupdate.%20I%20would%20appreciate%20any%20insight%20you%20can%20provide.%20The%20original%20source%20CSV%20is%20provided.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2375538%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm building a digital download photo website and have downloaded the wc-product" CSV UTF-8 database as a CSV files from my WooCommerce "Products">"Downloadable section. Instead of entering thousands of image file names and their image download URL's one by one, I intend to use the import/export tool within WooCommerce to add the filenames and corresponding URL's in bulk. While I do have 2 product categories, the one I'm working on presently is "Vintage Football Photos" - column "D" on the worksheet. I noted that each record for the images added for the downloadable product contains the "Download name" and the Download URL for each image and is numbered consecutively that is to say, Download 1 name, Download 2 URL and so on across the worksheet (colored fields beginning with "AU').

 

In creating the CSV for uploading/updating the downloadable products, what should I name the columns for the new items/data I'm adding and updating? When updating will the  "wc-products" CSV or database automatically add the new records, numbering them sequentially as is the exported source file? The feature in WooCommerce allows me to bulk update using a CSV file and specify which fields to import/update. I would appreciate any insight you can provide. The original source CSV is provided.

0 Replies