已取消

Create Affiliate Importable Website Data in Specified Format

Complete unfinished project: Previously compiled PHP code written for old system needs to be made to work with new system and be enhanced in a new database.

Summary of Project:

Access affiliate partner product sheets via FTP, match products from different affiliates and select the highest affiliate partner Rate, then combine with all unique products in a specified Big Commerce Import Format and "prepare the data" for import then import into Big Commerce.

Utilize supplied affiliate partner data to create desired Product Titles, Categories, Links to Affiliate Sites with Affiliate Logo (aka "Add To Cart" data), Meta Data, Product Description with Bullet List, images, etc.

"Add To Cart" Data: A Link To The Affiliate Partner Website. “Buy Now From: Affiliate Logo”. This information replaces the normal "add to cart" button by placing the code in a field within the Big Commerce import. The design and information included in the "Add to Cart" data needs to be able to be easily updated/changed.

Current Code:

1. [login to view URL]:

a) Logs in to the ftp site and downloads all the partner feeds into a directory.

b) Extracts the actual tsv files from the zip files which it downloads.

c) Creates the "raw" tables in the database if they do not already exist. If they do, it will wipe out the data.

d) Imports the tsv contents into the raw tables (raw_affiliate_<affiliate_id>, where affiliate_id is the id given from the partner feed)

e. Add or remove affiliate partners currently functions by adding or removing feeds from FTP folder

2. [login to view URL]:

iterates through all the raw rows of the affiliate partners and does the following:

a) Attempts to match the brand (exact match). If no brand match, then skip row.

b) Attempts to match the product using exact matching first, then various types of fuzzy matching, generating verbose output about what has matched (or has not matched). Outputs what it would have put into the add_to_cart _override field (but doesn't write that information yet)

3. common/[login to view URL]:

a) handles all the database queries, fuzzy matching, etc. Most of the hard logic lives here.

b) fuzzy and exact matches are currently output to the following:

No brand match

No product match (after all matching tests)

PRODUCT FOUND with exact match

FUZZY product matches (i.e. after Exact Match)

STRIPPED product matches (i.e. fuzzy match after the above which strips off everything but numbers and then checks that in all the codes (but only if you're left with something greater than three digits)

A working model of the output for the Big Commerce Import File exists in Excel. Use this to create code.

Additional New Code Needed For:

1. A well constructed fuzzy match may be necessary to match non-exact matches.

2. Check affiliate image links, create missing image report & don’t import product

3. Remove code for matching with old website and Update and improve product and brand fuzzy matching & fix skewed rows and columns

4. A list of discontinued products needs to be created for products that were previously in the Affiliate partners data, but are not found in the updated file

5. Use previously created Excel formulas as a guide to create the code for Import File For Big Commerce.

6. Need Brand Description field

7. Integration of product data into Big Commerce/automatic import

The php code and database needs to work on a PC. Information on System requirements including any software necessary to run the code must be provided in advance of the project being started.

Current Output can be viewed on www.slimargin.com. The "Add to Cart" data is the "Buy Now From: Affiliate Partner Logo" with Link

技能: HTML, MySQL, PHP, 网站设计, XML

查看更多: create data entry form access 2007, create data entry form access, create an access form for data entry, we are an ecommerce startup and require a data entry professional to enter product data into the website, we are an e-commerce startup and require a data entry professional to enter product data into the website, Create affiliate website, create a sql database and create a simple but good looking website where i can access and query the database, create hotel website data feed, create data capture form access, create spreadsheet website data, complete copy website data, format use upload product data feed prostores, create website data feed, create affiliate php website, want create job pulls xml data website, access data entry format, data entry format access, create website data submission, create login protect website, create estate agents website

关于此雇主:
( 0个评论 ) United States

项目ID: #16480486

33 威客就此工作平均出价 $1096

$1184 USD 在20天内
(653条评论)
9.0
drupaltonic

Hello! We've gone through your detailed project description and willing to do this work for you. Let's take this discussion ahead and make this project successful. Please go through some of our work: https://windyci 更多

$1250 USD 在20天内
(136条评论)
8.6
Eliteware

Hello Mate. I went through [login to view URL] I've worked on multiple projects with a similar description and would very much like to help with yours. Feel free to check out my reviews and leave a message if you want to se 更多

$1500 USD 在20天内
(56条评论)
7.9
$1250 USD 在20天内
(33条评论)
7.3
coolguyinus2004

You said "The php code and database needs to work on a PC. Information on System requirements including any software necessary to run the code must be provided in advance of the project being started." Dont you need th 更多

$863 USD 在10天内
(351条评论)
7.7
Shopify

Hello, Dear client we have checked your project [Create Affiliate Importable Website Data in Specified Format ] May I know about your business? What kind of website are you looking for?(like Basic information,eComme 更多

$1250 USD 在20天内
(29条评论)
7.1
AzzkaNoor

I have read your project details. I have to ask a few questions. Can you please message me via chat so we can discuss all the details to elicit all the requirements and hence start the development? I will showcase al 更多

$1250 USD 在20天内
(22条评论)
6.8
$1250 USD 在20天内
(143条评论)
6.7
$1250 USD 在20天内
(67条评论)
6.5
html5css3php5

Dear , I have well experienced PHP. I can do any modules use PHP. I completed more than 20 projects .

$1000 USD 在12天内
(159条评论)
7.1
king18yat

No advance payment is needed . I shall be able to start the work at the earliest and will complete in the time frame . Please join me to discuss the project scope.

$750 USD 在20天内
(30条评论)
6.3
EliZhang221

Php, NodeJs, Ruby, iPhone, iPad , Android, FireBase, Swift3, ObjectC We are team, we are having these skills under my belt. I’ve just checked your project “Create Affiliate Importable Website Data in Specified Format 更多

$750 USD 在20天内
(12条评论)
6.4
webmynesys

Hello Tracy, Hope you are doing well I have checked your requirements for the Affiliate product script development completely. We will customize the script as per the old code with the new technology so that you 更多

$1444 USD 在25天内
(81条评论)
7.0
$1250 USD 在20天内
(87条评论)
6.0
$1250 USD 在20天内
(13条评论)
6.1
dmitriyButeiko19

PHP Scripts which I wrote on Freelancer.com: https://www.freelancer.com/projects/javascript/Google-app-Script-16324428/ https://www.freelancer.com/projects/php/Help-turn-Node-function-into/ [login to view URL] 更多

$998 USD 在20天内
(83条评论)
5.8
ludwig333

hello i have read your description very carefully. i am full stack web developer. i can do your job in time

$1250 USD 在20天内
(28条评论)
5.9
quickleadsindia

Hi, Greetings from Quleiss Technologies ! Please let us know convenient time to connect online, we are very much interested to discuss your requirement in detail & prepare scope of work document for you before sh 更多

$750 USD 在20天内
(53条评论)
5.7
kirstarg

Hello! How are you? We have a few works like this. You can see my profile or see the links I have wrote above this, first if from my company. I can show you my works and talk about everything. My priority is get goo 更多

$1250 USD 在10天内
(20条评论)
5.6
akshayKelotra123

Hi I am well versed and having experience of 5+ years as Wordpress developer/designer. I believe that we can make a healthy relationship by working together. My technical skills are HTML5, CSS3, JavaScript, jquery, 更多

$888 USD 在3天内
(16条评论)
5.4