Multiple Versions of Several Products – SUGGESTION

[SMaz]

I have about 30 different templates I sell. They are for software that has several revisions in the course of the year. I am using the Digital Product Variation field to support selling templates for the last 3 versions of the software. This creates a lot of manual work each time a new version comes out.

CURRENT EXAMPLE: In the Digital Product Variation Field for each product, I currently have something like this:

Version|1.2::http://mysite.com/dloads/1.2/ProductName.zip|1.3::http://mysite.com/dloads/1.3/ProductName.zip|1.4::http://mysite.com/dloads/1.4/ProductName.zip

Ideally, it would be nice to specify variations for ALL products in a CATEGORY in one place – using a schema/token.

PROPOSED EXAMPLE (BY CATEGORY): Version|1.2|1.3|1.4::http://mysite.com/dloads/%Version%/ProductName.zip

[SMaz]

In light of my earlier post, is there a way/query to modify the Digital Product Variation field for all products in a Category, using the product name as part of the download file name. Like doing it through mySQL Query or something.

Using PSEUDO SQL – something like..

UPDATE ProdTable

SET [Digital Product Variation] = “Version|1.2::http://mysite.com/dloads/1.2/%5BProductName%5D.zip|1.3::http://mysite.com/dloads/1.3/%5BProductName%5D.zip|1.4::http://mysite.com/dloads/1.4/%5BProductName%5D.zip”

WHERE [Category]=2

[amin007]

All the product details is stored in your MySQL database so you can just write up a simple PHP script that modifies the value in the eStore’s product details table. The product details are kept in a table called “wp_wp_eStore_tbl”. So you can go to PHPMyAdmin and select that table then write your query to update the digital variation column. The name of the column is “variation3”

[SMaz]

Thanks. I’ll have a go at it.

[Author]

Posts