Find Jobs
Hire Freelancers

DATABASE / SORT SIZES / SORT COLORS

$30-100 USD

Completed
Posted over 16 years ago

$30-100 USD

Paid on delivery
I have a DB with 13000 itmes.... two key factors inside my ProductVariant table is: My SKU Field and my Manufacturer Part Field. The above fields will contain data like below for example: SKU / MANUFACTURERPARTNUMBER 1234 / FW1234SM 1235 / FW1234MD 1236 / FW1234LG 2345 / UA1234OR 2346 / UA1234BL 2347 / UA1234GR As you can see in the first three rows this item needs to be combined inside the ProductVariant table like below SKU / MANUFACTURERPARTNUMBER / SIZE / COLOR / SKUMODIFIERS null / FW1234 / Small, Medium, Large / null / 1234, 1235, 1236 and for the last three rows the data would look like: null / UA1234 / null / Orange, Black, Green / 2345,2346,2347 Please keep in mind that sizes and colors could vary... so please make it easy to make changes to the code to take this into consideration... for example an items sizes could look like: SM - SMALL, MD - MEDIUM, LG - LARGE and the next item could look like: XS - X-SMALL, SD - SMALL/MEDIUM, ML - MEDIUM/LARGE please make it easy to change or add size queries... ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform My database is a SQL 2005 DB... Please Use VB.NET 2005 as thats what I am most comfortable with.... I am NOT opposed to alterate methods such as C++ - I will just need some type of config settings that I can control - searches... for example - my vendor may decide to change wt = white to wwt = white one day... please take that into consideration
Project ID: 3180781

About the project

4 proposals
Remote project
Active 17 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$2 USD in 1 day
5.0 (6 reviews)
2.5
2.5
4 freelancers are bidding on average $35 USD for this job
User Avatar
See private message.
$76.50 USD in 1 day
5.0 (23 reviews)
4.8
4.8
User Avatar
See private message.
$42.50 USD in 1 day
4.4 (21 reviews)
3.2
3.2
User Avatar
See private message.
$17 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
9
Member since Apr 21, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.