Build book business data for online

Lukket Lagt ut 4 år siden Betales ved levering
Lukket Betales ved levering

Who we are ?

We are online seller with different market place . Recently we added Sale books online. Before we used to get data from one publisher so we were managing it using excel etc.

now we are going to have multiple supplier and selling on multiple market place. There data’s comes in million .. and data need to be update on daily basis such as new addition, out of stock , remove end of life sku etc.

There for we need this script.

About supplier data.

supplier Repro from india.

They give data in excel file .. which we can save as csv for import purpose.

Supplier : Ingram from usa.

We have to download there .dat file. We do not know much about this dat file. They give us seprate pdf help how to integrate the dat file for data import purpose.

Supplier give the information too many .. where we just need about few fields say about 10 to 12 filed only. Sku and isbn of the books is unique,

The stage 1 of this program.

A – inserting data into My sql by way of import CSV and Date file.

B – Defining Some vaues in a seprate table such as currency , conversion rate, margin , logistics, commission etc.

C – Making a quarry page from above data and downloading the result in CSV or View online.

That’s all

A – inserting data into My sql by way of import CSV and Date file.

=========================================================

A>>>> Supplier data :

After the table is created in mysql with your dump using phpmyadm

Approx. Fields is : SKU , date , isbn, title, weight, paperback type, offer price, discount, status etc.

You will give .php file example

[login to view URL]

When I open [login to view URL] there will be option as :

Insert Supplier Data

Browse Button …………..

Select over write or skip ( if found duplicate )

[] overwrite [] Skip

Upload button

if I select overwrite than it will overwrite if found same sku or isbn

if I select skip than it will skip if found same sku or isbn.

There will be one more this type of page to make item close or out of stock that will change the status value.

B >>>>> Market place. Data

Approx. Fields is : sku, isbn, title, sale price, currency, $Margins amount, $margin%

$ these will be calculated by script with the isbn help.

Here we will insert the data what we published. There will be only 5 or 6 filed in this only isbn data will be different.

B – Defining Some vaues in a separate table such as currency , conversion rate, margin , logistics, commission etc.

===============================================

amazonus margin

amazonuk margin

closing fee amazon us

closing fee … amazon uk

and so on……….

These will help when we fire quarry for result.

C – Making a quarry page from above data and downloading the result in CSV or View online.

================================================

There will be 10 to 12 quarry with the above insert data such as .

! example I want to have a file that yet to be publish on market place. And I need the information … of unpublished . in this scrpt will give me a file matching such isbn that is not into market place table .

this file can be like this .

Convert supplier price to my currency wijh this value [ ]

Add market place commission [ ]

add market place commission [ ]

Add logistic expenses [ ] % my currency [ ]

Add margin [ ] %

Submit

Script will calculate and will give a csv file for defend field.

Like tis there will be 8 to 10 more quarry

After completing the stage 1 in stage 2 we will relate our data with amazon for daily auto updating in real time using APi Key.

Find here the dat file and dat file information.

Dataregistrering Databehandling Excel PHP Nett-scraping

Prosjekt-ID: #19281136

Om prosjektet

9 bud Eksternt prosjekt Aktiv 4 år siden

9 frilansere byr i gjennomsnitt $140 for denne jobben

kkc264043kkc

Can make python script for importing the data. Can make ui in Python also Can use MySQL database These are my skills related to web scraping and crawling Have done scraping in CasperJS Phantomjs, python. Have do Mer

$250 USD på 3 dager
(42 Omtaler)
5.8
OmnisysSolutions

Dear, Hello, I am super experienced, detail orientated and strongly educated. If you want to get an amazing result you should award me I am best on the platform. SIncerely,

$111 USD på 1 dag
(3 Omtaler)
2.9
webappdevlop

Hey, Greeting of the day, I am palak, I have looking through your project requirements I have strong knowledge in { Website Design, PHP, Wordpress, Ecommerce, Magento, Opencart, HTML5, Jquery, Ajax, Javacript, Pl Mer

$155 USD på 3 dager
(3 Omtaler)
2.0
joshuamanthony

Firstly, the aim is to create an interactive and user-friendly website for you that can grasp the attention of branding and marketing. Secondly, the idea is to give a brief introduction to the brand for gaining consum Mer

$110 USD på 3 dager
(0 Omtaler)
0.0
Adnanqaiser

Hi, My name is Adnan Qaiser I have expertise in Microsoft Word, PDF and ETC. I have worked on many documents in my career so I have got all the required skills and experience in this regard. For me, real happiness is C Mer

$35 USD på 3 dager
(0 Omtaler)
0.0
sqlsantosh

i have good knowledge of data management and uploading part of e commerce platform Please contact me . i will be done your work in deadline.

$188 USD på 5 dager
(0 Omtaler)
0.0
qasimxlr786

Hi. I want to do this job . I will work fulfill on your requirements. Let me do my best to give you excellent results. Thanks.

$55 USD på 2 dager
(0 Omtaler)
0.0