Find Jobs
Hire Freelancers

DATABASE / SORT SIZES / SORT COLORS

$30-100 USD

已完成
已发布超过 16 年前

$30-100 USD

货到付款
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
项目 ID: 3180781

关于此项目

4提案
远程项目
活跃17 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$2 USD 在1天之内
5.0 (6条评论)
2.5
2.5
4威客以平均价$35 USD来参与此工作竞价
用户头像
See private message.
$76.50 USD 在1天之内
5.0 (23条评论)
4.8
4.8
用户头像
See private message.
$42.50 USD 在1天之内
4.4 (21条评论)
3.2
3.2
用户头像
See private message.
$17 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
5.0
9
会员自4月 21, 2006起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。