Archive

Posts Tagged ‘sku’

Need Custom Software/search Engine

February 7th, 2012 Comments off

Ok items with SKU’s on them I want this software to be able to put in that sku and find all websites that carry that item with that sku. For instance sku 83442212 might say 23 websites carry that item with that sku. (Similar to amazon or ebay when you search a product and shows you everyone that has that listed except it will show the website that has that item) This is one software of many for this new upcoming site, do a great job and many more software development will come your way. We are …

Javascript / Drop Down Menu

January 20th, 2012 Comments off

I need a drop down menu created and a field in the javascript conditionalized based on what is selected in the drop down menu:

Drop down menu content:
- iPhone Case
- Laptop Case
- iPad Case

Javascript code to conditionalize:
If iPhone
sku : ’98201′,

If iPad
sku : ’98202′,

If Laptop
sku : ’98203′,

I attached the full javascript code to the project.

Site Scraper

October 21st, 2011 Comments off

Hello I need a entire site scrapped.

Here is the site to scrap,
http://bit.ly/9vUk25

You should scrap products from the Sub Categories, For Example iPod & iPhone > Ipad

You should be also able to scrap products from New Arrivals & Top Sellers.

Scraping tool should allow me to start/resume scraping from the pages i specify, for example, page 18 and etc.

Product should be scraped with sorting order as New Arrivals.

I need the scraping tool as a desktop App.

I will need the following Information from the products,
For example, look at this product,
http://bit.ly/pl3vES

- NAME
- SKU
- PRICE
- Description (HTML TAGS)

General Spec  
Color red
Pattern Coca Cola
Material plastic
Function provide full protection for your device
Compatibility iPhone 4G
Features
Perfectly fit Apple iPhone 4G, with cuts to access all the controls.
Protect your valuable phone from scratch and damage.
Advanced design, all slots accessible without removing the case.
Perfect cutouts allow you to connect dock or charge without removing the skin.
Specially improved design allows for access to all ports and sensors.
High quality plastic material is very light and durable.

(i don’t need the stylings)
(just basic HTML)

- Short Description (HTML TAGS)

Weight:16.05 g
Size:11.7*6*1.1 cm
1

Data Extraction/ Data Entry 2

September 30th, 2011 Comments off

We have a large parts catalog that was created in InDesign. Attached is a pdf of a section of that catalog.

We need the information extracted into an Excel spreadsheet with the following fields: SKU,Name,Description, Price, imageFileName,category (section).

This is just an example of the catalog. Each item is called a SKU. Their are about 5000 sku’s total (about 300 pages).

The source indesign file is available or a pdf file.

100% of bid will be paid on delivery. Escrow is fine!

Not sure of the project budget so I put in $10-$200 .

Data Extraction/ Data Entry

September 14th, 2011 Comments off

We have a large parts catalog that was created in InDesign. Attached is a pdf of a section of that catalog.

We need the information extracted into an Excel spreadsheet with the following fields: SKU,Name,Description, Price, imageFileName,category (section).

This is just an example of the catalog. Each item is called a SKU. Their are about 5000 sku’s total (about 300 pages).

The source indesign file is available or a pdf file.

100% of bid will be paid on delivery. Escrow is fine!

Not sure of the project budget so I put in $10-$200 .

Scrap Project

August 28th, 2011 Comments off

Hello I need a entire site scrapped.

Here is the site to scrap,
http://www.wsdeal.com/

You should scrap products from the Sub Categories, For Example iPod & iPhone > Ipad

You should be also able to scrap products from New Arrivals & Top Sellers.

I need the scraping tool as a desktop App.

I will need the following Information from the products,
For example, look at this product,

http://www.wsdeal.com/CM121B/Soft_Silicone_Skin_CoverCase_for_iPad_Black.ws

- NAME
- SKU
- PRICE
- Description (HTML TAGS)

# Nice soft cover for Apple iPad.
# Case is molded perfect-fit for Apple iPad.
# Super quality materials of silicone rubber are more hard-wearing and solid than ordinary plastic.
# Full body protection case with two separate covers protects your iPad from scratches, bumps, and dings.
# Slim fit won’t make your iPad bulky and clumsy.
# Unique design allows easy access to all buttons, controls and ports without having to remove the skin.
# Easy to install and convenient to use.

- Short Description (HTML TAGS)

Product Details:
weight: 160 g
szie: 25 * 19.5 * 1 cm
Pack including:
1

Change Product Display In Cms Shop Builder From A-z 2

April 19th, 2011 Comments off

We are looking to have someone modify the CMS Shop Builder component on the following websites:

www.dogdealsdirect.com.au
www.catdealsdirect.com.au
www.birddealsdirect.com.au
www.rabbitdealsdirect.com.au
www.reptiledealsdirect.com.au
www.minipetdealsdirect.com.au
www.aquariumdealsdirect.com.au
www.horsedealsdirect.com.au
www.farmdealsdirect.com.au

Basically we need some way in the backend to control the order in which the products are displayed. For example we would like to display the products according to the first two letters in the product code (sku) so if I wanted to show all the products thats sku’s started with TR I could and then I could specify all the product sku’s starting with MD will be 2nd and so on. Please contact me if you require any further info.

Change Product Display In Cms Shop Builder From A-z

April 18th, 2011 Comments off

We are looking to have someone modify the CMS Shop Builder component on the following websites:

www.dogdealsdirect.com.au
www.catdealsdirect.com.au
www.birddealsdirect.com.au
www.rabbitdealsdirect.com.au
www.reptiledealsdirect.com.au
www.minipetdealsdirect.com.au
www.aquariumdealsdirect.com.au
www.horsedealsdirect.com.au
www.farmdealsdirect.com.au

Basically we need some way in the backend to control the order in which the products are displayed. For example we would like to display the products according to the first two letters in the product code (sku) so if I wanted to show all the products thats sku’s started with TR I could and then I could specify all the product sku’s starting with MD will be 2nd and so on. Please contact me if you require any further info.

Change Product Display In Cms Shop Builder From A-z

April 6th, 2011 Comments off

We are looking to have someone modify the CMS Shop Builder component on the following websites:

www.dogdealsdirect.com.au
www.catdealsdirect.com.au
www.birddealsdirect.com.au
www.rabbitdealsdirect.com.au
www.reptiledealsdirect.com.au
www.minipetdealsdirect.com.au
www.aquariumdealsdirect.com.au
www.horsedealsdirect.com.au
www.farmdealsdirect.com.au

Basically we need some way in the backend to control the order in which the products are displayed. For example we would like to display the products according to the first two letters in the product code (sku) so if I wanted to show all the products thats sku’s started with TR I could and then I could specify all the product sku’s starting with MD will be 2nd and so on. Please contact me if you require any further info.

Create Sku On Jewerly Items

January 16th, 2010 Comments off

Seeking someone to create sku numbers on jewelry items that display on the front end of each page.

Needs to be done in an os-commerce website.

Virtuemart – Spezific Sku Code

December 9th, 2009 Comments off

Virtuemart Extension

Data Comparison And Filter

June 1st, 2009 Comments off

I have a list of products which I drop ship – each product has a unique SKU but this covers the whole product and not the options. For example, a red shirt would be D1234 but a yellow car would also be D1234.

My suppliers publish an CSV file daily which lists their current stock situation – they, however, list their products with a different SKU per option so a red shirt would be D1234RED and a yellow car would be D1234YELLOW and so on. The supplier spreadsheet has three columns – SKU, description and qty. CUrrently there are 2400 line items on the supplier spreadsheet.

The saving grace is that the SKU schema I use for my products is similar to the supplier schema i.e in the shirts example above they both begin with D1234, for example. This is common across all the product lines, however, not all the SKU’s are one letter and then 4 numbers but this is reflected in my schema as well so, either way, they will be format on both columns.

In total I sell 172 unique products from this supplier so I have a spreadsheet with the 172 SKU’s as a single column and I then need a way of using my spreadsheet as a master list to filter out all the items on the suppliers spreadsheet which I don’t sell and therefore don’t need to be aware of any stock problems.

When this is completed I should then be left with approximately 300 items on the supplier spreadsheet which I will then manually check every few days for stock issues i.e. only the items which I sell.

I have no preference how this is achieved – if it can be done in Excel, Access great or if it can be achieved via PHP/MySQL it makes no difference to me but it must be able to scale and it has to be simple to use.

Basically all I want to have to do is to take two csv files and somehow compare and filter them and get an output list which shows the SKU, description and qty for each item and its variants for all the items I stock.

Form Upgrades

May 20th, 2009 Comments off

We have a file that hold information for different lots tied to a product.

1 – If you click on any of the links under lot you will see on the next page you will see the item section with 2 fields next to it. One is lot.item_sku (which equals product.id) and the other is lot.item (which is the same as product.name) Basically we want to have 1 ajax field that we can either enter the product.sku or product.name and when we select it enters the product.id into lot.item_sku and product.name into lot.item. We did something similar to this on another file that we no longer use if it’s helps you can look at it and copy and tweak the code.

2 – We have a section on the product page that we can upload an image of each product. I copied and changed the code so we could upload an image of each cofa for the lot but it’s not working. So we would like where the cofa section is to be able to select and image and have it upload to pics/cofa.

3 – On the lot main page you will see COFA on the right hand side. We would like this to only show up if the lot has an image uploaded and be a link that opens up in a separate window showing the image. So if a lot doesn’t have something in cofa then the link would not show. We have this same code on product.php if you’d like to just copy it from there and tweak it as needed.

4 – When adding a new lot the received date and exp_date calendars do not show so we need them to show up.

5 – Not every item has an exp_date so if it’s not to hard we’d like to have a checkbox next to the calendar that either puts NULL or N/A in the exp_date field.

6 – on the lot main page if you do a FIND for lot K820697 and click into it you will see the inventory says 1.11907e+08. I’m not sure why it shows up that way. It should show up something like 75274.93. So i’m guessing when the inventory gets too long it converts it into this weird #. Is it because the field is FLOAT? If so is there a way to get it to print out correctly? What are the advantages or disadvantages to float.

Add To Select Query

April 30th, 2009 Comments off

We have a script that has an issue. The problem is if we created a work order for the same product 4 different times in a year then it’s telling us to pull each item 4 times. So basically it’s pulling up info for all the work orders for this product…and we need it tied to only the current work order that we are working on.

The old code commented out didn’t have this problem so i looked at it and i see this:
LEFT JOIN work_order wo ON wo.id = ‘$work_order_id’

so that is what i think we are missing in the new code but i’m not a programmer and couldn’t figure out where or how to put it.

Here is the new code we have:
$res_herbs = $db->query(“SELECT p.sku, p.name, ph.herb, ph.qty, ph.lot, l.inventory
FROM product p, pulling_herbs ph, lot l
WHERE p.id
IN (

SELECT ph.herb
FROM pulling_herbs ph
LEFT JOIN pulling g ON ph.pulling_id = g.id
LEFT JOIN product p ON g.product = p.id
LEFT JOIN lot l ON l.id = ph.lot_id
WHERE p.sku = ‘$sku’
)
AND ph.herb
IN (

SELECT ph.herb
FROM pulling_herbs ph
LEFT JOIN pulling g ON ph.pulling_id = g.id
LEFT JOIN product p ON g.product = p.id
WHERE p.sku = ‘$sku’
)
AND p.id = ph.herb
AND l.id = ph.lot_id”);

So to clarify we don’t need anything taken away from the code…we just need it to only show the data that is tied to the work_order.id that we are currently working on.

Custom Joomla Module

April 23rd, 2009 Comments off

Hello,

I am in need of a custom Joomla module. I need to have full ownership rights and sole redistribution rights of the final product.

This module will be used with Overstock.com’s affiliate program. Overstock offers XML feeds of its products and I want to use those feeds to populate the module.

BRIEF DESCRIPTION

This module needs to be able to be customized by the user to create an XML call. Once the XML call has requested the needed information from Overstock.com it then needs to be parsed into a viewable module. (The output should look something similar to the products on this page: http://www.overstock.com/Home-Garden/Living-Room-Furniture/713/cat.html ). If someone is to click on the product, they need to be taken Overstock.com using the affiliate tracking code URL.

FULL PROJECT

STEP ONE: Setting up the XML Call

The user needs to be able to customize the XML call. This should be set up in the

Select And Insert Query Fixed

April 13th, 2009 Comments off

We have a script that tells us what items to pull down from a shelf to make up a product. We’ve changed db tables and names and need the script udated to the new info. Below is a list of items from a select statement that is no longer working.

Sku – should show from product.sku (tied together by pulling_herb.name = product.id)
Name – should show from product.name (tied together by pulling_herb.name = product.id)
Lot # – should show from pulling_herbs.lot
Qty – should show from pulling_herb.qty
Inventory – should show from lot.inventory (tied together by lot.id = pulling_herbs.lot_id)

We have checkboxes that we check once the item has been pulled down from the shelf but after we made the changes they were all disabled and should not be if we have inventory. So we need this updated also to the new db fields.

Lastly when finishing the ‘pulling’ job it’s updating some fields from pulling but 2 of them we don’t want updated any longer. They are id, so right now it’s adding 1 to the id but we need it to stay the same without adding 1. The last is product it currently has the id from the product table but is changing it to the item sku and we don’t want that. The rest are fine.

I’ll attach longer notes with code so you can see what your looking with. This shouldn’t take very long and ask any questions on the message board and we’d like it finished pretty quickly. Thanks.

Select And Insert Query Update

April 8th, 2009 Comments off

We have a script that tells us what items to pull down from a shelf to make up a product. We’ve changed db tables and names and need the script udated to the new info. Below is a list of items from a select statement that is no longer working.

Sku – should show from product.sku (tied together by pulling_herb.name = product.id)
Name – should show from product.name (tied together by pulling_herb.name = product.id)
Lot # – should show from pulling_herbs.lot
Qty – should show from pulling_herb.qty
Inventory – should show from lot.inventory (tied together by lot.id = pulling_herbs.lot_id)

We have checkboxes that we check once the item has been pulled fown from the shelf but after we made the changes they were all disabled and should not be if we have inventory. So we need this updated also to the new db fields.

Lastly when finishing the ‘pulling’ job it’s updating some fields from pulling but 2 of them we don’t want updated any longer. They are id, so right now it’s adding 1 to the id but we need it to stay the same without adding 1. The last is product it currently has the id from the product table but is changing it to the item sku and we don’t want that. The rest are fine.

I’ll attach longer notes with code so you can see what your looking with. This shouldn’t take very long and ask any questions on the message board and we’d like it finished pretty quickly. Thanks.

Fetching Web Data Into Epesi

April 1st, 2009 Comments off

Need a module working under EPESI custom platform. It will fetch/grab data on demand and daily basis from websites such as skapiec.pl, idealo.de, etc.
Data would have to be matched based on upc/ean, mpn, sku, product name, etc,… and displayed on a webpage with multi or single line items (if automatically can not be done it should be done manually).
The main goal is to scrape over 100 websites, rather close to 200. One scraper per website is fine as long as there is a configuration that will handle all the scrapers setting, etc.

Websites should contain:

Deliverables:
1) Complete and fully-functional working program(s) as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer’s environment–Deliverables must be installed by the Seller in ready-to-run condition in the Buyer’s environment.
b) For all others including software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered “work made for hire” under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder’s Seller Legal Agreement).
4) NDA

Requirements:
1. Has to work under EPESI platform located at http://sourceforge.net/projects/epesi
2. Common identification of products such as UPC/EAN, MPN, SKU. If no identification of product found it will be matched by Title.
3. Whenever possible use functions already used in the system, no overhead accepted
4. Products that are scrapped (grabbed) from price search websites should be matched as per specification
5. Products need to have price search action button next to it in WMS module as well ability to search using autocomplete function.
6. New sites to scrap should be easy to add (no more than 2 hour of work to add new site by admin) and utilize plugins
7. Sites that are already done have to be configurable in order for admin to make script corrections
8. Websites categories should be matched with categories in wms and ecommerce module, therefore with a single click desired products from a chosen category should be fetched. Action button in WMS module.
9. Multiple fetching hosts. Hosts will fetch data from multiple websites locations and place it in the same db. Master module will command slave modules how, when ,and from which website to fetch the data. Master module will tell which fetching host to use for which website. It should alternate randomly hosts and report any problems through alerter in EPESI. Active hosts will redistribute the load if there are problems with fetching. (something like load-balancing)
10. Websites categories should be indexed and saved for future fetching requests. It will have to be done periodically and if any current settings are changed send alert through EPESI to inform admin in order to make changes.
11. Implement on the fly translation in order to match categories and products info being fetched as well matching should be done base on sample of products in the category if identification at point 2 of the req. is not available.
12. Data should be stored in the database for easy retrieval as per EPESI project manager specification
14. Real-time exchange rates updates for different currencies
15. Number of entries to calculate average prices needs to be configurable
16. All Displayed columns has to be sorted.
17. When action initialized:
a)It will collect data once a day as a whole system
b)As a Category (list of products)
c)As a single product
18. Ability to add, remove columns (data)

Pages should have:
1. Manufacturer, Model, Description, vendor, Category, Lowest Price from website (will calculate currency based on the default selected) and actual lowest price, show percentage of difference between the lowest value and the website value
a) Highlight in green the price that is the lowest and in the red that is the highest.
b) Ability to click on the price to go to the particular website’s product page
c) Ability to remove vendors that have unreal prices from website or have very low ratings

2. Manufacturer, Model, Description, Category, Average Price of 5 (configurable) lowest entries from website (using the selected default currency), Average Price of 5 lowest entries using original currency, show percentage of difference between the lowest ave 5 and the highest website price
a) Highlight in green the price that is the lowest and in the red that is the highest
b) Ability to click on the ave. price to go to the particular website’s products page
c) Ability to remove vendors that have unreal prices from website or have very low ratings

3. Product Name, Description, 5 websites with the lowest prices (default currency), price range of 5 lowest websites (default currency), price range of 5 highest websites (default currency), percentage between average of 5 lowest and 5 highest website prices (default currency)
a) Ability to click on price to go to the particular website’s products page
b) Ability to remove vendors that have unreal prices from website or have very low ratings

4. Reporting module to Generate reports from the data stored in the database
a) The reporting module will have to work similar to crystal reports. I can create my own reports and the data would be populated on the website. Charting is not necessary but if it goes with reports it would be ok.
b) Products that have the highest percentage difference

It has to be easy to integrate into a website (modular design) and have admin site to control the configuration.
All parameters used should be configurable as per EPESI module administration
Additional website (price search engine) should be easy to add. The data grabber website should run without locking up, be fast and responsive.
The operation of the module has to be user friendly.

Platform:
EPESI,PHP,AJAX,JAVASCRIPT and MySQL DB

Additional questions.

UPC/EAN matching, MPN matching, SKU matching matching. IF no identification of product found it will be matched by Title.

Title matching should be automatic base on the probability…

1. If All words are present it would be 100% match.
2. If at least 2 words are matched and the rest is not it would be 75% match.
3. If 1 word is present it would be 25% match.
4. No match

The percentage of matching does not matter at this point it would have to be worked out.
The base for text matching is a Title of the product.
Point 1. “Nikon D90″ present everywhere would be 100% match
Point 2. “Nikon D90 body”, “Nikon D90 korpus”, “Nikon D90 kit” 75%
Point 3. “Nikon lens”, “Nikon flash”, “Nikon P80″ 25%
Point 4. None would be left in the repository for matching or deletion.

All 100% matches would be done without manual intervention.
The 75% matches would be shown to the end user as the best suggestion and accepted or not. If not it would have to be matched with the remaining products.
The 25% matches would be shown to the end user as the best suggestion. If not accepted it would have to be matched with the remaining products.
If products is matched it should be remembered.

Example:

Initial project will have 3 websites:

1. www.pricegrabber.com
2. www.idealo.de
3. www.skapiec.pl

Here is the sample of a page for Nikon D90 that info should be pulled and matched,
I think the best way to grab and match the data is based on categories, here is the sample of photo category:

http://cameras.pricegrabber.com/digital/Nikon-D90-Black-SLR-Digital-Body/m90725732.html/search=Nikon%20d90/st=product/sv=title
http://www.idealo.de/preisvergleich/OffersOfProduct/1124693_-d90-nikon.html

http://www.skapiec.pl/site/cat/2/comp/375159

Categories: Ajax, MySQL, PHP, Programming, SQL Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Epesi – Data – Fetching – Php

March 28th, 2009 Comments off

Need a module working under EPESI custom platform. It will fetch/grab data on demand and daily basis from websites such as pricegrabber.com, idealo.de, etc.
Data would have to be matched based on upc/ean, mpn, sku, product name, etc,… and displayed on a webpage with multi or single line items (if automatically can not be done it should be done manually).
The main goal is to scrape over 100 websites, rather close to 200. One scraper per website is fine as long as there is a configuration that will handle all the scrapers setting, etc.

Websites should contain:

Deliverables:
1) Complete and fully-functional working program(s) as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer’s environment–Deliverables must be installed by the Seller in ready-to-run condition in the Buyer’s environment.
b) For all others including software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered “work made for hire” under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder’s Seller Legal Agreement).
4) NDA

Requirements:
1. Has to work under EPESI platform located at http://sourceforge.net/projects/epesi
2. Common identification of products such as UPC/EAN, MPN, SKU. If no identification of product found it will be matched by Title.
3. Whenever possible use functions already used in the system, no overhead accepted
4. Products that are scrapped (grabbed) from price search websites should be matched as per specification
5. Products need to have price search action button next to it in WMS module as well ability to search using autocomplete function.
6. New sites to scrap should be easy to add (no more than 2 hour of work to add new site by admin) and utilize plugins
7. Sites that are already done have to be configurable in order for admin to make script corrections
8. Websites categories should be matched with categories in wms and ecommerce module, therefore with a single click desired products from a chosen category should be fetched. Action button in WMS module.
9. Multiple fetching hosts. Hosts will fetch data from multiple websites locations and place it in the same db. Master module will command slave modules how, when ,and from which website to fetch the data. Master module will tell which fetching host to use for which website. It should alternate randomly hosts and report any problems through alerter in EPESI. Active hosts will redistribute the load if there are problems with fetching. (something like load-balancing)
10. Websites categories should be indexed and saved for future fetching requests. It will have to be done periodically and if any current settings are changed send alert through EPESI to inform admin in order to make changes.
11. Implement on the fly translation in order to match categories and products info being fetched as well matching should be done base on sample of products in the category if identification at point 2 of the req. is not available.
12. Data should be stored in the database for easy retrieval as per EPESI project manager specification
14. Real-time exchange rates updates for different currencies
15. Number of entries to calculate average prices needs to be configurable
16. All Displayed columns has to be sorted.
17. When action initialized:
a)It will collect data once a day as a whole system
b)As a Category (list of products)
c)As a single product
18. Ability to add, remove columns (data)

Pages should have:
1. Manufacturer, Model, Description, vendor, Category, Lowest Price from website (will calculate currency based on the default selected) and actual lowest price, show percentage of difference between the lowest value and the website value
a) Highlight in green the price that is the lowest and in the red that is the highest.
b) Ability to click on the price to go to the particular website’s product page
c) Ability to remove vendors that have unreal prices from website or have very low ratings

2. Manufacturer, Model, Description, Category, Average Price of 5 (configurable) lowest entries from website (using the selected default currency), Average Price of 5 lowest entries using original currency, show percentage of difference between the lowest ave 5 and the highest website price
a) Highlight in green the price that is the lowest and in the red that is the highest
b) Ability to click on the ave. price to go to the particular website’s products page
c) Ability to remove vendors that have unreal prices from website or have very low ratings

3. Product Name, Description, 5 websites with the lowest prices (default currency), price range of 5 lowest websites (default currency), price range of 5 highest websites (default currency), percentage between average of 5 lowest and 5 highest website prices (default currency)
a) Ability to click on price to go to the particular website’s products page
b) Ability to remove vendors that have unreal prices from website or have very low ratings

4. Reporting module to Generate reports from the data stored in the database
a) The reporting module will have to work similar to crystal reports. I can create my own reports and the data would be populated on the website. Charting is not necessary but if it goes with reports it would be ok.
b) Products that have the highest percentage difference

It has to be easy to integrate into a website (modular design) and have admin site to control the configuration.
All parameters used should be configurable as per EPESI module administration
Additional website (price search engine) should be easy to add. The data grabber website should run without locking up, be fast and responsive.
The operation of the module has to be user friendly.

Platform:
EPESI,PHP,AJAX,JAVASCRIPT and MySQL DB

Additional questions.

UPC/EAN matching, MPN matching, SKU matching matching. IF no identification of product found it will be matched by Title.

Title matching should be automatic base on the probability…

1. If All words are present it would be 100% match.
2. If at least 2 words are matched and the rest is not it would be 75% match.
3. If 1 word is present it would be 25% match.
4. No match

The percentage of matching does not matter at this point it would have to be worked out.
The base for text matching is a Title of the product.
Point 1. “Nikon D90″ present everywhere would be 100% match
Point 2. “Nikon D90 body”, “Nikon D90 korpus”, “Nikon D90 kit” 75%
Point 3. “Nikon lens”, “Nikon flash”, “Nikon P80″ 25%
Point 4. None would be left in the repository for matching or deletion.

All 100% matches would be done without manual intervention.
The 75% matches would be shown to the end user as the best suggestion and accepted or not. If not it would have to be matched with the remaining products.
The 25% matches would be shown to the end user as the best suggestion. If not accepted it would have to be matched with the remaining products.
If products is matched it should be remembered.

Example:

Initial project will have 3 websites:

1. www.pricegrabber.com
2. www.idealo.de
3. www.skapiec.pl

Here is the sample of a page for Nikon D90 that info should be pulled and matched,
I think the best way to grab and match the data is based on categories, here is the sample of photo category:

http://cameras.pricegrabber.com/digital/Nikon-D90-Black-SLR-Digital-Body/m90725732.html/search=Nikon%20d90/st=product/sv=title
http://www.idealo.de/preisvergleich/OffersOfProduct/1124693_-d90-nikon.html

http://www.skapiec.pl/site/cat/2/comp/375159

Categories: Ajax, MySQL, PHP, Programming, SQL Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
Bear