- This topic has 3 replies, 2 voices, and was last updated 13 years, 11 months ago by .
Viewing 4 posts - 1 through 4 (of 4 total)
Viewing 4 posts - 1 through 4 (of 4 total)
- You must be logged in to reply to this topic.
Support site for Tips and Tricks HQ premium products
by
Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › Multiple Versions of Several Products – SUGGESTION
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
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
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”
Thanks. I’ll have a go at it.