Get a Freelance Job

We are looking for an experienced coder who can carry out the following request for a magento store:

1) the products we sell are going to be dispatched by our suppliers, not us, even though customer will buy from our site. Each time a product is bought, the supplier of that product needs to be sent an email, which includes product details, customer details, and a packing slip. From the customers point of view, the product has come through us.

2) from the admin part, we want to have an extra field for each product that lets us select the supplier of that product from a dropdown menu. This is the supplier which will then get an email once that particular project has been bought. It should be simple to change the supplier if we buy the product from another supplier.

This extension had been suggested http://www.magentocommerce.com/extension/2243/magento-embedded-erp but it doesn’t seem to carry out the requirements

Please PM if you have any questions.

Thanks

Hello,

**** The system should work with hebrew content ****

I am intersted in developing an internet platform which I will be able with to make a website in a commercial nich, for example realestate projects, to show projects being built in the area and type that the client will search for, wil show details like pictures and prices and in order to get more details or to be contacted by the supplier the client will leave information (this is the lead) and the supplier will get it and contact the customer.
The system will charge either monthly fee, or cost per lead in a way of bid, the higher you bid, the better exposer you get.
Add ons to this system is the ability to make a minisite for the supplier who pay monthly fee.
Of course the system should be highly developed to work with google which means SEO aspects like url’s in hebrew in .net3.5 and above.
We also need a design and the ability to run with the same system few websites in different fields. (of course a new design will be needed).
sample websites (in bebrew):
http://www.smart-group.co.il/index.php
http://www.zolim.co.il
http://www.1click.co.il/

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.