Forums

[resolved] WP e-Commerce update variations tables (2 posts)

  1. thebigA
    Member
    Posted 9 months ago #

    Hi

    I have inherited a hacked WP e-Commerce site Version 3.7.6.7 which has meant that with all the code changes we cannot update directly to the current version.

    This is generally not a problem however we now want to update a set of variation elements that relate to displaying prices for multiple purchase levels - these are not completed online they are more there as brochureware and the browsing customer phones in for an order.

    We associate the updates from the SKU that we hold.

    I have looked at the backend database and have realised that I can find the product_id from the productmeta table

    from there I have found that variation_properties holds the price breaks

    what I cannot seem to find is the associated text that goes with the properties. For example a lightbulb stress reliever has breaks at 500, 1000, 2500 and 5000 units with associated prices

    Finding the associated levels will help me identify the updates from our stock sheet and this would be a great advantage

  2. thebigA
    Member
    Posted 9 months ago #

    If anyone is interested I have now worked it out and am now in the process of building my update variations program.

Reply

You must log in to post.

About this Topic

Tags