SQL Database/Data creation
- or -
Post a project like this3532
£40(approx. $50)
- Posted:
- Proposals: 4
- Remote
- #534906
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the website: Opencart Website
Database management system (DBMS): MySQL
Kind of development: Customization of existing website
Description of requirements/features: Hi,
I need some help with the SQL database on my opencart installation. Essentially I need data creating in a table (as if it was added from the back end of the admin panel).
I am using 2 modifications, one is pack quantities and the other is discount groups.
The pack quantity modification allows you to sell in packs of 10pcs, to set this up you need to create discount groups on every item for every discount group.
Hopefully the image of the table attached to the post will explain better.
So product_id 827 has 6 customer groups (1-6), for each group it includes the price and packs of 10pcs.
I need the above creating for every product ID to be able to import it into the database, so the only variables are the product ID and price, customer_group_id is constant 1-6 and packs is always 10.
Happy to pay anyone willing to help me solve this as it would be very time consuming for me to go through every product ID manually.
There are over 800 product ID's each with 6 customer groups so nearly 5000 lines to add to the SQL table.
Extra notes:
Database management system (DBMS): MySQL
Kind of development: Customization of existing website
Description of requirements/features: Hi,
I need some help with the SQL database on my opencart installation. Essentially I need data creating in a table (as if it was added from the back end of the admin panel).
I am using 2 modifications, one is pack quantities and the other is discount groups.
The pack quantity modification allows you to sell in packs of 10pcs, to set this up you need to create discount groups on every item for every discount group.
Hopefully the image of the table attached to the post will explain better.
So product_id 827 has 6 customer groups (1-6), for each group it includes the price and packs of 10pcs.
I need the above creating for every product ID to be able to import it into the database, so the only variables are the product ID and price, customer_group_id is constant 1-6 and packs is always 10.
Happy to pay anyone willing to help me solve this as it would be very time consuming for me to go through every product ID manually.
There are over 800 product ID's each with 6 customer groups so nearly 5000 lines to add to the SQL table.
Extra notes:
Jordan H.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
50%
Last project
11 Nov 2014
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies