Käynnissä

Oscommerce Selective CSV Product Updater/Populator

Oscommerce custom add-on description:

**ALL CONFIGURATION OPTIONS MUST BE ACCESSIBLE THROUGH THE ADMINISTRATOR CONTROL PANEL**

Step 1: every XX amount of minutes/hours/days the script needs to download a CSV file (or multiple CSV files) from a specific URL. There should be a manual upload option. Here you select which Scenario(s) to apply.

--Scenario Manager--

Step 2: Based on my configured selections the script will scan for a specific product(s) or if all products is selected it will scan for all products within the CSV.

Step 3: Once products have been singled out, products must add/update whichever fields I selected into my Oscommerce DB(mySQL) (with an option of updating into multiple Oscommerce mySQL DBs).

Step 4: A configurable option should be available which will allow for price markup by certain amount of dollars or %. This should be allowed for any fields that I select. (Regular price, sale price, shipping price, etc..)

Extra details:

- Configurations from Step 2 through 4 should be saved as a scenario each time, allowing for multiple and different configurations done for each single upload based on the launching of multiple Scenarios.

- Typical fields which will be updated are Regular price, sale price, shipping price, image, and product description. These are just examples. The script must be able to update from all available fields in the CSV into all available fields in Oscommerce. I should be able to mix and match if I like.

- The scan will look for a specific product identifier which the user (me) will specify. This could be a word/number from a specific field or a combination of fields.

- The csv scanner must be standardly compatible with configurable options such as, comma delimited, semi colon delimited, etc..

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Control Panel configuration outline:

1. File fetch (here I see the status and log of previous and current fetch [succeed/fail+why] and can cancel any currently running Auto Fetch.

a. Auto Fetch (here I also select which scenario(s) to apply)

b. Manual one-time upload (here I also select which scenario(s) to

apply)

2. Product & field selector

a. Scenario Creator (each scenario should include:)

I. Select all products or find specific products based on

identifier word/number)

II. Select wanted fields in CSV and select fields in Oscommerce

DB that you would like to add/update the CSV fields into.

III. Price markup option (on Oscommerce DB side only, after new

price is added/updated from CSV). This includes options such as: + dollar

amount, + %, etc.. and may be applied to all fields including normal price, sale price, shipping price

etc..

Be smart with your code. Don't let common errors like if the field i selected from the CSV does not exist in the CSV it will erase everything under the target field for update/add in the Oscommerce DB.

* A CSV EXAMPLE IS INCLUDED!!! *

** Please add an optional extra quote for reading from mySQL DB and MS SQL DB in your communications **

*** I plan on using the attached zip for "on sale" prices (it adds a 'products_msrp' to the db if I am correct). If you'd prefer I used a different script that's fine, please let me know. All other fields are standard Oscommerce. ***

++++++++ COMMUNICATION IS KEY, ASK ANY AND ALL QUESTIONS YOU HAVE ANYTIME!!! If we need to advance communication methods let us know. ++++++++

It is worth mentioning that this is a 3 step script.

1. Fetch CSV(s) and store on local HD (overwrite old same name CSV)

2. add/update Oscommerce DB based on selected config options that will extract specific data (or all data) from the CSV file.

3. Markup price by set dollar amount or + %

*** I plan on using the attached zip for "on sale" prices (it adds a 'products_msrp' to the db if I am correct). If you'd prefer I used a different script that's fine, please let me know. All other fields are standard Oscommerce. ***

Zip file mentioned earlier attached now.

*********************************************************

PLEASE DOWNLOAD PROJECT IMAGES FOR DETAILED PROJECT DESCRIPTION AND FUNCTIONALITY DISPLAY.

*********************************************************

*********************************************************

FEED IMAGES UPDATED 06/14/09 (minor cosmetics + settings)

PLEASE DOWNLOAD PROJECT IMAGES FOR DETAILED PROJECT DESCRIPTION AND FUNCTIONALITY DISPLAY.

*********************************************************

Taidot: tietojenkäsittely, PHP, Komentosarjan asennus, Ostoskärryt

Näytä lisää: colon, product updater, wanted it manager, update oscommerce 2.2 to 2.3.1, status manager, single match, product-manager, panel methods, panel configuration, oscommerce 2.2, log creator, fine products, find creator, dollar everything, dollar days, common questions, common current, advance.auto, a description of a product, oscommerce update mysql csv, dear sir please let know progress buy products, oscommerce product csv, csv product attributes oscommerce, csv requirement india industry, cart custom products quick books integration

Tietoa työnantajasta:
( 35 arvostelua ) miami, United States

Projektin tunnus: #450069

Myönnetty käyttäjälle:

wildCat

check pm, please

400 $ USD 5 päivässä
(321 arvostelua)
8.4

16 freelanceria on tarjonnut keskimäärin 332 $ tähän työhön

ambar

Dear Sir, Please check my private message. Thanks Shome.

325 $ USD 10 päivässä
(108 arvostelua)
7.9
oscworker

please check a PMB.

350 $ USD 1 päivässä
(96 arvostelua)
6.9
webedeveloper

Highly experienced and serious team ready to take this job, please view pmb

350 $ USD 7 päivässä
(106 arvostelua)
6.9
websoftinfo

Hi, we are very [url removed, login to view] have gone through with the requirements you described in your detail. We can easily do it with our [url removed, login to view] will provide you regular updates during progress, if we get this.... And als Lisää

400 $ USD 20 päivässä
(71 arvostelua)
6.5
techendura

Dear Sir I have experienced and expertise in oscommerce fields. please view PMB about my developed oscommerce sites I hope that you will provide this job to me and reply to me as soon as possible. Regards Raj

400 $ USD 7 päivässä
(48 arvostelua)
6.2
Pektsekye

can you write a file with all the details?

400 $ USD 21 päivässä
(107 arvostelua)
5.6
lucky2gaf

Hi, please view my PM for details, thanks.

400 $ USD 10 päivässä
(43 arvostelua)
5.3
ktechindia

Hello, We can provide you right solution in least possible time. Hope to work with you. thanks, Kumar

300 $ USD 15 päivässä
(32 arvostelua)
4.4
yourssincerely

hi, osc expert here, ready to start. thanks.

350 $ USD 3 päivässä
(9 arvostelua)
4.3
Manshasolution

Hi, We are an Indian team having good experience in working on Os-commerce, Joomla, Drupal, Wordpress, Php mysql etc. We are highly interested in working on this project. Please view your PM for more details and sam Lisää

340 $ USD 10 päivässä
(3 arvostelua)
3.0
beesoft

Kindly check your PMB for details. Thank you

400 $ USD 3 päivässä
(2 arvostelua)
1.8
CreativeITWorld

please, check my pm.

100 $ USD 7 päivässä
(0 arvostelua)
0.0
rashed1996

Please check PM

350 $ USD 0 päivässä
(0 arvostelua)
0.0
rntsolutions

R&T Solutions is an IT solution and service provider company. We provide a full range of offshore software development services from staff augmentation through to application development and consultancy. We cater to sm Lisää

250 $ USD 7 päivässä
(0 arvostelua)
0.0
Malshiv01

I wish to finish this project on a very effective [url removed, login to view] have experince in handling files and Excel , so will be able to fulfil your requirements. Thanks

200 $ USD 20 päivässä
(0 arvostelua)
0.0