Closed

Import Tool for OpenCart base website

Our online store sells a large number of products. We get weekly product feeds from suppliers which need to be imported into the database.

Please see website: [url removed, login to view]

CURRENT PROCESS

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

FILES RECEIVED:

We receive files from 3 types of vendors in three scenarios:

Scenario 1) large vendor with over 30,000 products. We get about 10 small flat files (tab separated CIF) format. We manually import into excel for processing.

Scenario 2) Excel file is received from vendor, we just copy required columns across to the import file in excel. About 2,000 products

Scenario 3) Specialised vendor only has a few products and data does not change. Less than 100 products each. So we just import the same data every week.

CONVERSION PROCESS:

We use a number of macros and VBA to import the data into an excel file.

- Product description is refined using a few fields concatenated with HTML tags.

- Most fields are simply copied across (such as product name, manufacturer code, model weight etc).

- Data is cleaned to remove reference to supplier name. This applies mainly for support and warranty fields.

- Some fields are calculated such as product sale price. We have rule for pricing and margin calculation.

- Product ID needs to be numeric. one of the small supplier (Scenario 2 above), does not provide numeric (max 11 digits) product code. We need to generate unique manufacturer code for these products.

- For product without weight provided we put a value of 20kg. Which means they need to contact us before checking out.

- New product Images are downloaded from the supplier FTP server and uploaded to our website. If image is not available, we simply display the manufacturer's logo instead.

- We also get a related products file from vendors, these columns are to be converted to the one field for import and de-duplicated. Otherwise import will fail.

- Product Categories are converted to our product categories. You will be provided with a lookup table.

- The promotional rates and specials tab data is also provided.

IMPORT PROCESS:

- The default import truncates the tables, so we need to import everything again every week.

- We filter out some product groups which we don't want to sell in our store.

- The large file is split into 3 or more smaller files as the default import engine does not allow all the records to be imported in one go.

- We backup database before import using MySQL utility.

- Files are imported in 3 or 4 batches and backed up in between.

WHAT IS REQUIRED:

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

We want to reduce the rework and have the system automated.

We would like to have a tool that helps import all the data and does the calculation during import process.

We would also like to have an import too for importing into MySQL database.

The tool should also check to see if it is a new product to download required images.

The tool should remove old promotions and specials data and new data should be imported with start and end dates.

OUR TERMS AND CONDITIONS

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

TERMS OF BUSINESS

- We will maintain ownership of all complete and incomplete project work.

- You will be paid 10% on commencement and the remainder on completion of project.

- You may use our company as a project reference but you may not use the website name without prior written permission.

- Upon completion you will provide all source files and runtime files to us.

- You may not keep a copy of the data or source files on your computer.

- Must sign NDAs

EVALUATION CRITERIA:

- All bids for this work will be assessed based on merit

- Acceptance of terms of businsess

- You need to have demonstrated experience doing similar work. Any previous experience on OpenCart will be considered.

- You will need to provide project references, who will be contacted.

- Work needs to be delivered on time and in budget

- Warranty must be provided

- The import tool needs to have a friendly GUI.

- You need to have good English communication skills phone and emails.

Sample file for SCENARIO 1 supplier (Ingram Micro).

Please see Summary tab for name of files included. It has a list of all files received from them, as well as the description of the file.
- Follow the links under the Name column to see the file details.
- Follow the Sample link to see sample data.
- Please note that the full files would have several thousand records.

Project Requirements v1.0 slides uploaded.

Project design:
We feel it may be best to break down the project into two phases:
1) The Data Collection Tool; built (such as a .NET application), it will pull all the information from several files into one file for import.
2) The import utility / application / add-in which allows importing from the large file into OpenCart database.

Technical Specifications v1.0 file uploaded.

Developers should review. You may bid for one phase or both two phases.

Skills: .NET, Excel, MySQL, PHP, Software Architecture

See more: opencart import tool, opencart import, data import opencart, importing excel opencart, import data excel file opencart, opencart product name price import excel, opencart import excel tool, opencart import mysql, opencart backup excel, import opencart, who to use as references, who to put as references, what business to start using excel, vba get data from website, utility gui, types of online business, types of logo for new company, tool for filter data online, the rule to use logo of company, suppliers for business, supplier manufacturer, small business server online, sell your logo online, sell your code online, sale logo online

About the Employer:
( 2 reviews ) Hornsby Height, Australia

Project ID: #1344744

19 freelancers are bidding on average $553 for this job

buraqtech

Check your PMB for details!!!

$750 AUD in 18 days
(62 Reviews)
7.6
sunztech

Please see PMB.

$750 AUD in 10 days
(35 Reviews)
7.4
CodeGuru123

Hi, Hope you are doing good. I have gone through your requirement. I did similar kind integration with ICECAT and Etilize database. Please msg me for more details. Thanks Sam

$750 AUD in 20 days
(50 Reviews)
6.9
Soolved

i can help to you. kindly check your pmb. many thank.

$550 AUD in 23 days
(63 Reviews)
6.0
z0mbie

Expert .NET, C#, ASP developer with a history of built similar applications. Please check PM for more details.

$800 AUD in 7 days
(21 Reviews)
5.3
nazir

I have done similar translation software before, that would read file in one format and transfer it into another format or copy them into a database after doing some maths, such as accounts or transaction, using visual More

$500 AUD in 7 days
(1 Review)
5.0
yhermanto

Hello, i can complete this job. regards,

$600 AUD in 10 days
(16 Reviews)
4.7
keyprompt

We are interesting in your project for more information check your private message box. Thanks

$700 AUD in 20 days
(4 Reviews)
3.6
emagicians

Hi As India' s Leading web development company, Mindgenies, we provide high standards of quality and a dedicated teams for our project with a 24*7 support. If you are looking for quality and high standards of wor More

$600 AUD in 30 days
(0 Reviews)
0.0
shreyarola

Respected Client Please check my PBm for more details thanks

$700 AUD in 10 days
(0 Reviews)
0.0
apdanial

i want do this work but i am new at lancer

$540 AUD in 4 days
(0 Reviews)
0.0
kevinorange282

PLEASE CHECK PMB

$700 AUD in 7 days
(0 Reviews)
0.0
bequangtuyen

I'm Opencart developer.

$300 AUD in 7 days
(0 Reviews)
0.0
happyman1234

i am ready for this projext

$250 AUD in 10 days
(0 Reviews)
0.0
harryinfotech29

please chk pmb

$600 AUD in 4 days
(0 Reviews)
0.0
thanhhuyit

I have lots experience in .Net programming and Visual Basic Application. Reply me and we could go on with a discussion in detail.

$350 AUD in 10 days
(0 Reviews)
0.0
threescomnet

Hi, I would like to work on your project. Please consider PM for more info.

$250 AUD in 15 days
(0 Reviews)
0.0
poojanitingupta

Whole Product will take at least 7 dev days. I have nice exposure to Visual Studio / access. We can work together to get final product ready. I support minor changes for 1 year, with no cost.

$400 AUD in 10 days
(0 Reviews)
0.0
technotech002

Dear Sir, We are having a team of technologies expert working in different technologies like php,Joomla, Smarty,.net, C with our company. We are fully Profession Company and believe to give you full return for which More

$500 AUD in 5 days
(0 Reviews)
0.0
Manvi73

we have good experience of macros....

$666 AUD in 22 days
(0 Reviews)
3.6