Build book business data for online
$30-250 USD
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.
Prosjekt-ID: #19281136
Om prosjektet
9 frilansere byr i gjennomsnitt $140 for denne jobben
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
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,
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
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
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
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.
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.