Is there an explanation of PRODUCT.csv headers?

[dwbone]

I am using WP CSV to DB plugin to load our e-Store cart. It worked perfectly. Great add-on.

Is there an explanation for the field headers in the PRODUCT.csv template / e-Store Database? i.e. what are field headers: a1, p1, t1, sra, srt, ref_text, etc… used for? What data is held in each field? Some fields are obvious, most are not.

And how do they correspond to the options in the WP e-Store product set-up?

Thanks

(BTW: This is post is “reposted” in part from previous unanswered post – this new post and title are more specific.)

[wzp]

The field headers, correspond (of course) to the various columns in the product database table. These columns in turn, correspond to the various option settings for each of your products.

The intent of the WP CSV to DB tool is to assist with the initial bulk transfer/porting of product information from “other” eCommerce solutions into eStore. Once that has been accomplished, you should be relying on eStore’s internal product edit/management capabilities.

Many of the field headers (columns) are unique and internal to eStore. As such, apart from the obvious field names; you should not be dependent upon being able to set/edit the values of product settings, via the WP CSV to DB tool. Please understand that, publicly documenting this information would prevent us from making required internal changes to the product database table; as we see fit.

If you are truly insistent upon doing so however, you *could* reverse engineer the field headers, by creating a “dummy product,” with uniquely coded values for the various settings; and then observe, under what field/column headers, these values appear in the product database table. We would not object to your doing so, but we are not obligated to warrant or, maintain the names or usage, of the internal field/column names you discover; as per term 7 of the eStore license agreement.

http://www.tipsandtricks-hq.com/ecommerce/wp-estore-license-479

With that said, the following are used for when you create a subscription product:

a1, p1, t1, sra, srt

[dwbone]

Thanks wzp for your explanation,

Perhaps I can explain our specific needs;

We sell downloadable music. Each song title has downloadable “variations”

SONG TITLE.mp3 / Karaoke.mp3 / Sheet Music.pdf / Lyrics.pdf / Video.mov

180 song titles and their digital variations, I’d like to enter the data via excel, then upload the DB.

The e-Store Admin offers and excellent set-up for digital variations, however, I don’t see which field this data is stored in within the CSV file that I’ve imported into excel, I don’t see the cell(s) that contain my test products’ DIGITAL variations field(s).

Am I missing it?

Thanks, again.

[wzp]

What you need to do is create a single “dummy product,” with variations in the Add/Manage Products panel. Then, go into phpMyAdmin and look directly at the wp_eStore_tbl table for the dummy product. You can then see which column headers (fields) correspond to which settings.

Hint: Just because there are 4 variation settings, doesn’t mean they’re going to be adjacent to each other in the database table.

[admin]

The following video tutorial will likely be helpful for you too:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

[dwbone]

Thanks again for your responses,

I did create dummy products, and went into phpMyAdmin, and even imported the data back into excel to review, … and i have read and watch the tutorials; however..finally, after digging around the db I did finally figured out that the digital variable field, which for anyone else looking… is contained in the “Variation3” column.

The individual digital variations are NOT stored in separate fields/columns (which is what I was expecting/looking for). They are stored in a single cell, lead by the variable’s name, (i.e.. SIZE) followed by a ” | ” divider ( – each variation is separated by a ” | ” — the variation details, (price, description…) are separated by a double colon ” :: ”

Not as neat as one might like for managing variations and extensive product line, but I did find it. (it would be nice if digital variations had their own fields).

Thanks again.

[dwbone]

I did create dummy “test” products as i mentioned in my previous post, and went into phpMyAdmin and searched, and even imported the data back into excel to review, but wasn’t seeing it. btw, I have read and watched the tutorials- blah blah blah – but my post wasn’t asking for basics.

—anyway, finally after digging around the db I figured out that the digital variable field, (which for anyone else looking) is contained in the “Variation3″ column. The individual digital variations are not stored in separate fields/columns (which is what I was expecting/looking for). They are stored in a single cell, lead by the variable’s name, (i.e.. SIZE) followed by a ” | ” divider ( – each variation is separated by a ” | ” )– the variation details, (price, description…) are separated by a double colon ” :: “

(surprised you folks didn’t know that)

Not as neat as one might like for managing variations and extensive product line, but I did find it. (it would be nice if digital variations had their own fields).

[wzp]

There are 4 variations; three physical, and a fourth digital. As I previously said, the variations will not be adjacent to each other in the table. In other words, see what you get when you create a dummy product with data in all 4 variation fields.

The format you saw within the variation field is in keeping with the established documentation.

http://www.tipsandtricks-hq.com/ecommerce/how-to-use-variation-control-in-wordpress-estore-plugin-345

I know it sounds like we’re trying to be difficult, but you are asking us to provide advanced information that a professional developer might want, that is above and beyond the scope of these forums. We expect that a person wanting that kind of information can find it; if we gave enough hints, without ending up doing their development work.

If you require development assistance; we do offer a custom work order program. Simply complete the quote request form, and someone will get back to you:

https://support.tipsandtricks-hq.com/need-custom-work-done

[dwbone]

Okay, coming back-atcha now – (this is really an extension of previous post.)

Thank you again, (didn’t think you were being difficult, btw – no hard feelings, sometimes forum Q&A’s don’t always get to the heart of the question) – anyway, I have since gotten to understanding the digital variation coding better… and have successfully mass duplicated relevant product data within excel and upload to the cart.. awesome.

— Now, I am attempting to do bulk updating of the per product Category,

I have 734 products and 14 possible categories setup in eStore admin… so, in Excel, I’d like to indicate which category a product belongs to (rather than going through eStore admin and indicating category one product at time).

It would appear that category is “affirmed” in t1 and t3 fields with a letter “D”. However, no matter which category I select per product within eStore admin these fields are filled with a letter “D” – there doesn’t seem so be a field that contains which category the product specifically belongs in.

I am wondering where the specified category (per product) is stored in the database / csv.

Thanks for any insight.

[admin]

The “Assigning Category To Your Bulk Uploaded Products” section of the following documentation will help:

http://www.tipsandtricks-hq.com/ecommerce/how-to-bulk-upload-estore-products-from-a-csv-file-775

[dwbone]

Ah ha! thank you.

[Author]

Posts