Closed

Build book business data for online

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.

Skills: Data Entry, Data Processing, Excel, PHP, Web Scraping

See more: data strategy how to profit from a world of big data pdf, data strategy: how to profit from a world of big data, analytics and the internet of things pdf, data strategy book pdf, data strategy books, data strategy bernard marr pdf, building the internet of things maciej kranz pdf, data strategy bernard marr pdf free download, building the internet of things pdf, freelance scrape small business data, build front end data entry, excel macro data online, data online dhaka, book cover free online, grab data online database, build card bot magic online, business plan online gaming company, copy paste data online, business plan online projects, online book keeping data entry operator, online book store data system

About the Employer:
( 0 reviews ) mumbai, India

Project ID: #19281136

10 freelancers are bidding on average $136 for this job

quinconx

Hey there, I am a full stack web developer. I build websites and software solutions for businesses and startups to help their sales and marketing. I have more than a decade of combined experience in Web Designin More

$200 USD in 14 days
(53 Reviews)
6.5
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 More

$250 USD in 3 days
(35 Reviews)
5.1
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 in 1 day
(3 Reviews)
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 More

$155 USD in 3 days
(1 Review)
1.7
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 More

$110 USD in 3 days
(0 Reviews)
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 More

$35 USD in 3 days
(0 Reviews)
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 in 5 days
(0 Reviews)
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 in 2 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
waseemsaleemg

Hi Dear, Our best concern is to follow your requirement and deadline and we will do our best for the success of your project. Feel free to send message to discuss your project with us. Thank you very much! Surely, we More

$100 USD in 2 days
(0 Reviews)
0.0