This is using the OpenCart shopping cart system, it doesn't matter if you have never used this before, the tables are clean and I need your help updating them.
There are ~4 tables that store product options, one table to store possible options and ID's a second to match value names to them, then these are attached to products using two more tables, one for names and one for id's from the previous tables and product ids.
I need to be able to
1. Add options to the options tables
2. Add options to products
3. Update options on products
All via PHP with no hijacking of the core of Opencart, so it's straight PHP & MySQL.
The tables are straight forwards to do, my personal SQL skills are not up to the job and require your assistance. The options are coming from a well formatted XML file.
As mentioned above, please don't apply if you're unable to look at this today and also include "Howdy" in your reply, so I know you've read the job description.
Remember Skype is a must for this, so that we're able to hammer this out in text chat (voice calls are not absolutely required).
If you have any questions ask & MySQL access will be provided to database.