AutoSnipe Posted September 14, 2013 Report Share Posted September 14, 2013 Hi there, my site heavily relies on coupons and i am trying to work it out.. i see the 3 tables "coupons", "coupons_amounts" & "coupons_packages" the coupons packages is my problem.. i have inserted a coupon to the database with the last product in my database. "46" it also has the pricing_id for the url is 133. but on the pricing_table.package_id it is 47. but if i do product 1 it is 1 as the product. how does this all work?? as i may have multiple coupons for the same product at different amounts.. hopefully someone understands what im trying to say. Cheers, Ryan. Quote Link to comment Share on other sites More sharing options...
0 Michael Posted September 14, 2013 Report Share Posted September 14, 2013 How come your not making them in the admin area mate? Quote Link to comment Share on other sites More sharing options...
0 AutoSnipe Posted September 14, 2013 Author Report Share Posted September 14, 2013 they get made by my actual site's script. Quote Link to comment Share on other sites More sharing options...
0 Michael Posted September 14, 2013 Report Share Posted September 14, 2013 Oh you might need the guys to help you Quote Link to comment Share on other sites More sharing options...
0 AutoSnipe Posted September 14, 2013 Author Report Share Posted September 14, 2013 Just worked it out i think.. here is what i have put it too... if it has the option for monthly, quaterly or yearly. (as far as i can tell because my product id for '1' is only a single item for 1 month) it stays the number. if it has any payment options it has id+1. i've just put that in my script to see what happened and 3 of them have worked so far.. by all means michael, check it out (buydedi.com) let me know what you think.. down the bottom "haggle" Michael 1 Quote Link to comment Share on other sites More sharing options...
0 Michael Posted September 14, 2013 Report Share Posted September 14, 2013 Haha that's cool mate. Quote Link to comment Share on other sites More sharing options...
0 AutoSnipe Posted September 14, 2013 Author Report Share Posted September 14, 2013 thought it was a slightly unique idea.. better then hetzner's "auctions" at least the user gets a slight say to make it cheaper then to make it more expensive Michael 1 Quote Link to comment Share on other sites More sharing options...
0 Cody Posted September 14, 2013 Report Share Posted September 14, 2013 Package pricing ID values really have nothing to do with package IDs. Everytime a package is created one or more package pricing options are created as well. Package pricings are stored in the package_pricing table. Don't rely on package pricing IDs being functionally determined by package ID. Michael 1 Quote Link to comment Share on other sites More sharing options...
0 AutoSnipe Posted September 15, 2013 Author Report Share Posted September 15, 2013 Ok now worked it out. Got the product I'd from the products area. ) Michael 1 Quote Link to comment Share on other sites More sharing options...
Question
AutoSnipe
Hi there, my site heavily relies on coupons and i am trying to work it out..
i see the 3 tables
"coupons", "coupons_amounts" & "coupons_packages"
the coupons packages is my problem..
i have inserted a coupon to the database with the last product in my database.
"46"
it also has the pricing_id for the url is 133.
but on the pricing_table.package_id it is 47.
but if i do product 1 it is 1 as the product.
how does this all work?? as i may have multiple coupons for the same product at different amounts..
hopefully someone understands what im trying to say.
Cheers,
Ryan.
Link to comment
Share on other sites
8 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.