Category: PHP Projects

PHP Projects

Oscommerce / Zencart Icecat

Oscommerce / Zencart Icecat
Project title: Oscommerce / Zen Cart / Magento distribution connector with ICEcat.biz ( i have attached the details in word doc)

We are electronics company e-commerce website. I would like to move our current store to zencart / oscommerce or Magento shopping cart. we already have hosting package and would like to know how we can integrate… we work with top distributors to download our products… and our main concern is we would like to download all products details from ICEcat.biz site, which offers FREE products content.

this is how we want…

from our supplier we will have our custom price feed which include, the followings:

* SKU#
* MPN#
* Manufacturer
* product title
* category
* short description
* Images

from ICEcat.biz we want the following:

* Product Specification
* Full descriptions
* UPC code
* Images

The Description from ICEcat will be presented in the description tab
The images from ICEcat will be presented in the description tab
The Specification from ICEcat will be presented in the Specification tab
The product reviews from ICEcat will be presented in the reviews Tab.
(if available on ICEcat)

I don’t want to download duplicate proudcts, meaning I want the same product from my supplier and then that product details, specification, images from ICEcat.

I would like to upload new products from a distributor data feed
At the end of the project I expect to receive a data feed in TXT or CSV format

Purposes

This Project is intended to automate product import from multiple distributors into a Magento / Oscommerce / Zencart environment.

Project planning

1. Distributor automated imports
1.1 Mapping interface (manufacturers/categories)
1.2 Import interfaces
1.2.1 Synnex
1.2.2 Ingram
1.3 Distri import dashboard
1.4 Distributor selector
1.4.1 Backoffice: setting up rules for distributor selection
1.4.2 Import system: finding the best match across distributors
2. Content import from ICEcat
2.1 XML import of product datasheet & Sync mechanism to update product data
2.2 Product comparison functionality
2.3 Product lookup functionality
3. End-user price calculation module
3.1 Price rules interface
3.2 Price calculation mechanism
4. Real-Time stock & price check
4.1 Distri interfaces for real-time P&A
4.1.1 Synnex
4.1.2 Ingram
4.2 FrontOffice P&A check integration (AJAX driven, no pop-ups)
4.3 BackOffice P&A check integration into Purchase Advice
5. Purchase Advice Module
5.1 Create & save purchase advices
5.2 Consolidated purchase advices
6. Electronic ordering at distributors
6.1 Generic ordering mechanism
6.1.1 Synnex
6.2.2.1 Order
6.2.2.2 Status feedback and shipping advice
6.1.2 Ingram
6.2.2.1 Order
6.2.2.2 Status feedback and shipping advice
7. Initial environment setup
7.1. Custom look&feel design
7.2. Implementation in Magento
8. SEO optimization
8.1 URL Rewrites
8.2 Titles, meta tags (incl description and keyword) optimization
Basic points

Offers automated import

The purpose is to fully automate product offers import from distributors. Further extension of imports with adding new distris should be simple enough.

Import will need to have some mapping capabilities, which should be interfaced in the backoffice of the Magento. ICEcat can provide a categorization advise in most cases, but you have to be compatible with ICEcat category structure, which is multilevel and derived from UNSPSC. The same stands for manufacturers list.

Interface/screens required:
– Map vendors (from distri data into standard vendor)
– Map categories (from distri data into standard category)
– Distri import status screen (import dashboard)

Distri selector module

In case of multiple distributors connected, this module will be needed to resolve ambiguities in product assortment and optimize product coverage in shop.

It will create a best products selection, based on distri selection rules. Rules can sounds like:
– Find the best price among [SELECTION] offers

Where [SELECTION] could be defined by parameters:
– Manufacturer / Any manufacturer
– Category / Any category
– Partnumber

Assortment in the environment will be refreshed after every successful import job and / or in the end of batch session timeframe. Batch session timeframe = time when assortment updates in shop isn’t significant, e.g. from 01:00 till 07:00. This is to lower the server load.

Interface required:
– Distri selector rules input

ICEcat content import module

Content import module will import content from ICEcat XML repository. It will put it into a local database, and data will be shown on product details page.

Data to be imported are:
– Product names / descriptions
– Images / gallery / multimedia
– Specification
– Related products (x-selling / up-selling data)

Currently no backoffice interface is supposed for this data management, existing data storage tables should be used as much as possible.

Data will be stored in local database in a well-structured form, suitable for lookup and product comparison.

In the frontoffice there should be a possibility to compare selected products (in one category) and to find products matching certain criterias.

As soon as no backoffice for data management is supposed, all search settings are to be re-used as they are setup in ICEcat (ICEcat provides certain defaults, as you can see in www.icecat.biz)

The search will be filter-based – a user will have possibility to create a product filter based on:
– manufacturer
– stock (yes/no)
– price breaks
– Specification (search breaks will be based on ICEcat searchable features)

End-User Pricing

End user price is calculated on “Purchase price + Margin” model.

Margin could be calculated by a rules, which are defined in a backoffice. Rules format is
– If [CONDITION] then marge = [MARGE DEFINED]

Where a [CONDITION] is a combination of:
– Purchase price condition ( purchase price between A and B)
– Vendor = [A | Any]
– Category = [ A | Any]
– Product code = [A | None]

“A” is a parameter, as defined in rules setup. Rules are to be managed from a backoffice.

Real-Time stock & price check

As distributors provide interface for real-time Price and Availability (P&A) check, it could be implemented in front-office and backoffice to provide the real-time info on request.

In frontoffice it will be integrated via a link, which will start AJAX request for an update. Server will perform the parallelized requests to distributors and return the result to user page. No popups here, only a stock quantity will be updated and during a check there will be an indicdation that the request is currently in progress.

Purchase advice module

Purchase advise module should give a best economically efficient advice on ordering, on following parameters:
– Product price
– Shipping costs
– Product availability
Formalization of the computational task is:

order amount with stock > 0  max

purchase amount + order costs  min

This is an integer-valued multiple dimension multiple criteria task, which solution will cost a lot of CPU power(all possible combinations has to be checked to find the best alternative.

Before the purchase advice generation, stock / price information is validated at distributor.

a. Drop shipments
Dropshipments should have an individual advice (per-order)

b. Collection point orders
Module should create a shared consolidated purchase advice for all sales orders waiting for purchase

Purchase advice can be customized by shop manager & saved customized.

As soon as purchase advise is generated and accepted, orders status is changed so orders don’t get an advice more then once.

In the backoffice, the integration with real-time P&A is possible– to have the most up-to-date information, Purchase Advice module will automatically request P&A info on items which are to be purchased. This is to have the most up-to-date information for Purchase Advice creation.

Interface required:
– Sale orders list to PA
– PA preview
– PA management:
o Status flow
o Distri feedback
o View PA data (delivery info, order info)

Electronic ordering at distributors

As soon as purchase advice is verified by shopmanager, it could be automatically sent to distributor and purchased.

Each distributor have it’s own interface, so a “driver” for every distributor is required.

After order will be sent to distributor, it will be put on a status meaning “Purchased”. This is to avoid double orderings.

If during ordering an error happened, it will be put on special status “Error in upload”, which would indicate a problem in order upload.

Status feedback functionality will pickup data from distributor and import them into environment, so status handling data will be visible.

Initial environment setup

This involves creation of own look & feel design and customization of standard Magento templates to your own branded look & feel.

That includes custom look & feel graphical mockups creation. They will be approved by you, and then frontpage look and feel will be adjusted to match the mockups.

SEO optimization

Every category page and product detail page can be automatically optimized for a better SEO ranking:

• The page title and meta tags (description and keyword) will be customized
• URL will be adjusted in the following way: category.website.com/(subcategory)-mpn.html (or –productname.html)

There will be a possibility to optimize titles, meta tags (inc descriptions and keywords) for all category/product pages through BackOfficce.

Export to Google Shopping / Google Sitemaps

Export to google shopping / google sitemaps can be performed on a daily basis, automatically. The export file will contain information about all “in stock” products.
Efforts and costs estimation
Below are the rough costs & efforts estimation for the functionality as described above.

Item | Phase I
1. Distributor automated imports
1.1 Mapping interface (manufacturers/categories)
1.2 Import interfaces
1.2.1 Synnex
1.2.2 Ingram
1.3 Distri import dashboard
1.4 Distributor selector
1.4.1 Backoffice: setting up rules for distributor selection
1.4.2 Import system: finding the best match across distributors
2. Content import from ICEcat
2.1 XML import of product datasheet & Sync mechanism to update product data
2.2 Product comparison functionality
2.3 Product lookup functionality (filters)
3. End-user price calculation module
3.1 Price rules interface
3.2 Price calculation mechanism
4. Real-Time stock & price check
4.1 Distri interfaces for real-time P&A
4.1.1 Synnex
4.1.2 Ingram
4.2 FrontOffice P&A check integration (AJAX driven, no pop-ups)
4.3 BackOffice P&A check integration into Purchase Advice
5. Purchase Advice Module
5.3 Create & save purchase advices
5.4 Consolidated purchase advices
6. Electronic ordering at distributors
6.2 Generic ordering mechanism
6.2.1 Synnex
6.2.1.1 Order
6.2.1.2 Status feedback and shipping advice
6.2.2 Ingram
6.2.2.1 Order
6.2.2.2 Status feedback and shipping advice
7. Initial environment setup
7.1 Custom look&feel design and proofpaging
7.2 Implementation in Magento*
8. SEO optimization
8.1 URL Rewrites
8.2 Titles, meta tags (incl description and keyword) optimization
Export to Google Shopping / Google Sitemaps

Php Wishlist Script

Php Wishlist Script
What I need is a script written in PHP that will allow registered users to create their own wishlist.

First a user will need to click a link on a the navigation menu that states “Create a wishlist,” I would then like this to take them to a form where they create the title of the wish list. Each member should be able to create more then one list if they choose.

After it has been created they now get an option to “Add an item” to the wishlist. When one goes to add a item the following fields need to be available for the user to fill out..Title, Item Description, Estimated Cost, Primary URL(where they can post a link to the item they want), Secondary URL, Quantity Requested, and finally a drop down box for Priority of item (nice to have, i really want this, thinking about it).

Once the user submits this it gets added to their wishlist and is viewable by other registered members. This is the tricky part, I then want users to be able to cross items off of each others lists (like when they purchase the item and want to mark it so others know not to get it.) but while other users can view that the item that has been purchased the original user who posted the item cannot see that the item has been crossed off. The point of this is so that the person who posted the item will not be able to see what he is getting if he were to look at his list.

As items get crossed off I want them to stay on the lists but just be marked as purchased.

If this is hard to comprehend please check out the drupal module “wishlist” the demo is here.. http://wishlist.mclewin.com/

I love how that module works but I do not want to have to use drupal. (http://drupal.org/project/wishlist)

You can even download the wishlist module and use that as a basis for this project if it will help.

I can provide more detail and even screenshots of how I will want this to look if you need it.

Fix Contact Form

Fix Contact Form
I have a contact us form. It is in a flash page, but the form submits to a PHP page. The info is not getting emailed correctly.

It could be as simple as a mis-spelled email address. It could be a php error, or it could be a problem of the Flash form not passing the info correctly. I think it will be an easy project but whatever the problem is, I will need for you to fix it.

It is using a custom PHP script.

I will not send the page URL until I award you the project. At that time you can look at the website before accepting the project.

After you accept, I will give you FTP login info and you will need to fix it whatever the problem is.

Here are some screenshots:
http://174.132.166.251/~outsourc/Screenshots/Public/2010-04-07_2033.png
http://174.132.166.251/~outsourc/Screenshots/Public/2010-04-07_2034.png

I just do not have time to do this myself.

Thanks,
Daniel

Site With Events + Data Import

Site With Events + Data Import
I have a basic skeleton of the site done in html which I will provide so it will be clear what needs to be done.

Scripting must be done in php5.x, for ajax preferably latest jQuery. Site will use Mysql5.x
also htacess must be used for nice looking URLs

Site’s elements:
— Register —
registering with e-mail, pass, captcha (captcha from recaptcha.net)
(with sending e-mail with activation link in it)
ajax checking if e-mail exists and if passwords match

— Login —
e-mail, pass (after few bad tries, show Captcha as anti abuse), remember user, recover password

— Associate user(s) with account —
(much ajax here)
user name, user continent, user country (drop down list for cont. and country) => check if it doesn’t exist, then import his info by extracting a few text strings from an external site
* User is asked to modify some info on that external site
* User clicks Verify button
* After that we import the info from external site and check if it’s correct
* If it’s successful we store all his data in our database and associate this user with his account

— Add an event with a “Bad Guy” — (temporary name)
(much ajax here)
each account with associated user can add a new event with a Bad Guy
* select one of the associated users, after that get his info from database and show below (with ajax)

Date, Bad Guy name, Building, Room (list of Buildings and Rooms to choose from are taken from our database)
Verify button, when clicked we retrieve 2 data strings from 2 external sites and verify if they match

Product ID (user enters a product ID, this can be entered in various formats so we convert to proper ID if needed. We then import the Product’s name based on the ID from our database. If not present in database we import it from an external site and save to our database. When product ID submited we show the product’s name and display another field for next Product ID (with ajax))

Add photos: (user adds a photo, which we convert to previously set quality and resolution as well as generate a thumbnail and store them. After it’s submitted we use ajax to show the submitted photo’s thumbnail and show next field for another photo)

Add comment:

[Submit]
// Submitting stores all the data above in our database

— Search Bad Guys —
Search for Bad Guys (visitors can search for all events which a Bad Guy took part in)
(we display results as Bad Guy and Events, with multiple info taken from our database)

— Browse Bad Guys —
After choosing Continent and Country we display all Bad Guys from that Continent and Country and events associated with them)

— Viewing an Event and adding data to it —
Rating (1-25 scale, based on user votes)
Bad Guy info, Continent, Country
Event added by – user who added event and when added
Date & time of event, Building, Room, Products, Screenshots, Comments

Fields for adding/removing score for Rating, comments by other users, screenshots by other users (additional check required using data from external site to see if current user can post comments)

Report – a message reporting to admin if something’s inappropriate in this event

— Tracking change of Name, Country —
Every successfully added Event adds a Bad Guy to a special list in admin panel. Admin uses it to retrieve “additional data” about each Bad Guy from an external site and store it into database.
After that if users suspect Bad Guy’s data changed (name, country) and know the new info, they can use a form to submit it to our site and we compare if the “additional data” matches. If it does, Bad Guy is stored with a new name and new other info from now on. But we still store his old info somewhere.

— Bad Guy profile —
display name, Continent, Country and other data as well as old name, Country and others if any
and display all events in which this Bad Guy took part in

There’s a Report new data form for users (explained in “Tracking change” section)

— Account settings —
change password, change e-mail (new confirmation e-mail), list associated users with the option to remove them.

— Admin panel —

* list of events (with sorting, able to delete)
* import country lists into database (from textarea or input file)
* import building and rooms list into database (from textarea or input file) along with their desired names on our site. For example if on the external site one building is called “shop5” and I want it to be shown as “Shop number 5” then I want to include it on the list.
* import “additional data” of Bad Guys (with sorting)
* reports (show messages list, with sorting)
* ban list (list of banned users with sorting and form to ban users that abused the site disallowing them from adding events/comments)

Also admin must be able to edit/remove any of the comments, screenshots, events

Seo For Magento Based Site

Seo For Magento Based Site
We are looking for a SEO expert to work on ecommerce site. The site is about ‘wedding rings’ related products. Listed below are they keywords I would like to do SEO for. The site is using Magento Ecommerce Platform.

– I need some kind of commitment from you that you can get my website back onto the first page of Google under “wedding rings”. I know, “it’s impossible to give guarantees”. Convince me that you can get this done and give me a realistic time-frame.
– Look at the 12 search terms above and give me a commitment on where you believe that you can get my website listed in Google under these terms and what the time-frame is that you can achieve this.
– Show me proof, based upon current projects, that you have achieved page one rankings in Google for websites using very competitive search terms. I would like to see at least three examples of websites you have worked on with the search terms that you have achieved these rankings for.

wedding bands
unique wedding rings
custom wedding rings
diamond wedding rings
men’s wedding rings
platinum wedding rings
antique wedding rings
gold wedding rings
titanium wedding rings
two-tone wedding rings
wedding ring sets
womens wedding rings

Fun Website Development

Fun Website Development
We have a great e commerce web development project. We would like to create a website with the look and function of www.crocs.com. This would be different as the products are completely different yet have similar function and basic structure.

The attitude is fun and humorous as is our product. We are looking for developer that really enjoys creativity, has a great sense of humor and likes to help people laugh and smile with their creativity.

Communication and staying on the timeline once agreed is very important.

We will require both a wholesale section and a retail section to the shopping cart. We like the look of the www.crocs.com shopping cart as well and if possible we would like to use OS Commerce. If not we are open to other shopping carts.

The candidate should have great examples of websites that they have developed to show.

This can lead to further work as well.

Convert Smarty Php Ereg Func

Convert Smarty Php Ereg Func
Looking for someone to quickly convert 24 ereg functions to preg_match. It appears that the web server for this website has upgraded to php 5.3 and it is now receiving the “Deprecated: Function ereg() is deprecated in /home/unisourc/public_html/include.php on line 20”

This site uses Smarty Template so you must be experienced with Smarty. Tell me if you think this is the right solution and why.

Automatic List A-z For Vbullet

Automatic List A-z For Vbullet
Hi,
I would like the simple product for vbulletin 3.8.4.

The product is an a-z List ,it works with the topics,when someone creates a topic in automatic the name(with link) of this topic is in the a-z list .

If you look the example here:
http://www.animedb.tv/forum/pages.php

I need ,if possible,the product in xml file like a very vbulletin product ,for upload it like the others Vb product.

in this product I have to choose:

-for what forum i want use it
-What group can see it
-some stats:how many visit,how many answer,author of the topic ect..

that’s all thanks

Callback Script

Callback Script
I need callback php script.

The script needs to change one icon with another when called back.

i also need another script that monitor the page and allows for a submit button to be activated when all the callback script have been activated.

Exemple:

A visitor comes to my page, he sees 3 links with red cross next to them and a text field with a submit button. The submit button cannot be clicked on right now.
it click on 3 links that open in new pages/tab. When he finish filling the forms on those 3 pages, a callback script is used to change the red crosses cross to green checks.

When their is 3 crosses the visitor can click on the submit button.

Php Output Of Mysql Data

Php Output Of Mysql Data
i need a csv databse inputted in to mysql, then outputed onto php seo mod rewritten pages.

i want the output to drop into my sites template. i will need to specify title tags, meta descrip and keyword tags.

in summary i need to get the data onto php seo modwritten pages of my site template.

i have included some instructions from data provider.