Đang Thực Hiện

OSCommerce Price & Stock updates from CSV file

We have access to a daily 'Price and availability' and a 'promotions' feed file for our products from our supplier. They come as a csv file. The purpose of the these files is to have up to date stock and pricing.

PART 1 - Price and Availability File

This file is available from an FTP location so if the job can start by automatically downloading the file to a temp folder on the server.

The FREE STOCK column gives a figure of how many are in stock and needs to be transferred directly to products_quantity

The REPORT column contains a series of codes which relate to delivery times. Each code needs to be mapped to a String which then populates products_availabilty_status. Example: code MD should be mapped to string 'Usually Dispatched Within 72hrs'. I require that the mapping of codes to strings be done from admin so that they can be easily modified.

Column REPORT DATE with a REPORT code of 'NYP' means that the book will be available from that date. In this case the stock should be 0 but the date used to populate products_date_available and the 'NYP' code mapped to string 'Pre Order Now' or similar.

Each product is described by its ISBN13 number so can be easily matched to products within the database. Any ISBN numbers not found within the database should output to a log file for investigation.

PART 2 - Promotions File

This file is available from an FTP location so if the job can start by automatically downloading the file to a temp folder on the server.

This file just needs to be used to populate set special offers. Each book can be located by ISBN number and the promotional discount used to set the special offer price. The FINISH DATE field can be used to populate the end date for the special offer.

PART 3 - Pricing

For the pricing part of the feed files we need to be able to set up rules which will be used to set our own prices for each product. I have attached a text file with the first draft of the pricing matrix. Ideally I would want to be able to create pricing rules from within admin so these can be easily modified and added to as necessary. This would give much more flexibility than hard coding the pricing rules.

Finally, some kind of confirmation / error handling needs to be outputted so that we know the whole file has been processed correctly and completely.

I think this covers the spec but if you have any questions please let me know. I would be grateful to have you estimate for this job as an time frame for completion.

Kỹ năng: MySQL, PHP, Thiết lập Bản thảo

Xem thêm: oscommerce csv stock report, price availability file, will price, purpose means, product supplier database, product covers, price file, php codes free, order book covers, md now, job stock, free php codes, discount offers, csv codes, time come, md n, job price, job mapping, stock, isbn, investigation, in stock, grateful, csv php, access script error

Về Bên Thuê:
( 8 nhận xét ) London, United Kingdom

Mã Dự Án: #1014580

Đã trao cho:

oscworker

Please check a PMB.

$400 USD trong 5 ngày
(69 Đánh Giá)
6.5

18 freelancer đang chào giá trung bình $511 cho công việc này

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$450 USD trong 7 ngày
(237 Đánh Giá)
7.8
DevExpert

Hello, as you can see in my profile i am experienced in all kind of e-commerce development (and not only). I would like to help you with this project, my price includes further support and if any bugs found after proje Thêm

$500 USD trong 5 ngày
(130 Đánh Giá)
7.4
tomydeveloper

Hello,We Oscommerce / Feeds /Daily deal site expert.Please check pmb.Thanks

$500 USD trong 4 ngày
(208 Đánh Giá)
7.4
mrroberto

hi, i can help you. i did very many different import scripts for oscommerce and i am expert with it. if you interested, contact me. regards, roberto

$299 USD trong 3 ngày
(211 Đánh Giá)
7.3
humashahid80

Hi, Immediately ready for your project, please check PM for details.

$650 USD trong 20 ngày
(55 Đánh Giá)
6.9
softwaredep

Lets start. See PMB for more information. Thank you.

$500 USD trong 8 ngày
(103 Đánh Giá)
6.9
kev2me

I have 6+ years of modding experience with Oscommerce. Hopefully my feedback tells you what kind of programmer I am.

$400 USD trong 5 ngày
(76 Đánh Giá)
6.0
eurekasoftwares

In my 7+ years of experience I have extensive experience on OsCommerce where I have worked on many customizations. Can you please supply the three relevant CSV files? I need to see these for a quote.

$250 USD trong 0 ngày
(16 Đánh Giá)
5.9
PHPsoldier

DEAR SIR, OSCOMMERCE EXPERT HERE. CAN DO IT. IT WOULD BE GREAT IF YOU COULD SUPPLY A SAMPLE csv FILE. MANY THANKS....

$400 USD trong 5 ngày
(47 Đánh Giá)
5.6
softwarevamp

Hello, ready to start!

$350 USD trong 5 ngày
(23 Đánh Giá)
4.8
binhtq

HI, I have more than 4 years with Oscommerce. I can do it. Best Regards

$400 USD trong 5 ngày
(14 Đánh Giá)
4.7
bcddevpro

Hi, please check your pmb for more info.

$500 USD trong 4 ngày
(3 Đánh Giá)
4.0
sunsriinfosys

Hi, I have over 12 years of Experience in software design, development and implementation of various commercial applications in Client/Server environment, Web and ERP applications using C# 1.1/2.0/3.5, ASP.Net, VB.N Thêm

$600 USD trong 20 ngày
(6 Đánh Giá)
3.6
arunmangal16

Dear sir, I have taken a look of your project which you have just posted onto the website. Here by performing the keen analysis of the project I can say that it would be easy to develop this one. Actually I work for Thêm

$932 USD trong 25 ngày
(0 Đánh Giá)
0.0
Colnovator

Hi,can be done.Please check PMB for more details. Thanks& Regards Richa

$745 USD trong 20 ngày
(0 Đánh Giá)
2.4
websolutionspath

Hi, I have 4+ exp In programming , skype id Freelancer_nagendra and mail id is engineer dot nagendra at gmail dot com i did several project related to your project and I can easy do this job please check my pmb and b Thêm

$700 USD trong 5 ngày
(0 Đánh Giá)
0.0
imageaUK

Quite complex custom coding but all possible :-)

$625 USD trong 10 ngày
(0 Đánh Giá)
0.0