Author: Blancer

Multiple Suppliers Extensin
Our suppliers keeps a file in .xls or CSV format in a password protected directory that is updated every day and is periodically assigned a new password to access it. The products in the list and in our product database need to be synchronized every day to disable discontinued products and adjust price changes that take effect from the .xls or CSV file. We also will have a margin table lookup file that will have to be cross referenced in order to determine the correct pricing. Below is an example of the process:
Get file from supplier directory -> Apply prices based on margins set in lookup file -> Set prices accordingly and disable discontinued items in Magento Cart.

Example 1: After automatically logging in and moving the .xls or CSV file to our server, the synch process should begin. A product is listed in the .xls or csv file, and has a base price set at $ 19.99. It has a product number of ‘123456′. The product has a manufacturer code of ‘123′. During the synchronization, the script should analyze the manufacturer, then cross reference with our margin table by manufacturer code, (for this example manufacturer code ‘123′ has a markup of 15%.) It would then apply the markup to the base price and set the price of the product on Magento Cart at $ 22.99 (rounding up to the nearest $ 0.99). It would then move to the next product.

Example 2: The script comes across a product in the .xls or csv file with a note that says ‘DISC’. It would automatically disable the product in Magento Cart.

III. Important Fields:

Supplier .xls file –
SUPPLIER_NUMBER = the identifier for a specific manufacturer, which will be used to apply margins
STOCK_CODE = this identifies the product within the MagentoCart product database
SELLING_PRICE = this is the base price that will be adjusted by the margin lookup file
DISCONTINUED = if blank, this product is still current. If it contains the value ‘DISC’, it should be taken off of the site
NOTE: If there are any products that are on the .xls sheet, but not in the Magento Cart already, it should output them into a single .xls file

Margin Table Lookup File –
SUPPLIER_NUMBER = the identifier for a specific manufacturer, which will be used to apply margins
MARGIN = This will be a number between 0-100 that will determine what needs to be added to a product.
(equation: roundtonearest99cents(baseprice x 1.(MARGIN)) = newprice)
NOTE: The Margin Table Lookup File only contains Suppliers and their margins. Individual products will not be included in this file.

IV. Multiple Supplier Integration:

This project also needs to be expandable to other suppliers that we have, so that changes can be made to files or settings in the Magento Cart admin.

For the admin, we want to have an extra field for each product that lets us select the supplier of that product from a dropdown menu. Each product is assigned to a particular supplier. This is the supplier which will then get an email once that particular product has been bought. It should be simple to change the supplier if we buy the same product from another supplier. When importing products should be automatically assigned to the supplier of the products uploaded.

There should be a list of the Multiple suppliers which you can click to get to the product list of the particular supplier.
There should be a list of manufacturers which you can click to get to a product list of the manufacturer.

Manual Pricing Options to be added to the Admin: Ability to manually override the Price on each product or en mass by checking all products for a supplier

1. Flat Dollar Amount Markup: For this option – the dollar amount to add to your wholesale cost for all products for a flat dollar amount profit margin.

2.Flat Percentage Markup: For this option – the percentage to use for all of your products to add to the cost. For example, if your margin is 30% and a product costs $100, your retail price will be set at $130.

3. Dollar Amount Markup: the dollar amount settings based on the wholesale cost of the item. The cost tiers to use and the price markup you want to associate with each tier. For example, from $0-20 add $5, from $21-50 add $11, and so on.

4.Tiered Percentage Markup: Tier your percentage settings based on the wholesale cost of the item. The cost tiers to use and the percentage markup you want to associate with each tier. For example, from $0-20 add 50%, from $21-50 add 45%, and so on.

5.MSRP Pricing: Base the pricing relative to the MSRP of each product. You can specify a dollar amount or percentage to discount from the MSRP, or you can have your pricing set to the actual MSRP. Include any discount below that price if you want one.

Replace Existing Shopping Cart
would like to replace existing cart with a new os cart. As to which cart, your suggestion is appreciated.
Cart must have the same appearance as the site, be very user and customer friendly. Must also be fully functional at completion of the project. User training if needed.

Site is perl and operates on a Linex server.

Clipshare Error
I use the clipshare video script for a site that has 6000 current members. Very recently a player upgrade and search mod was purchased and soon after my site started exhibiting all kinds of errors which I am unable to fix. I have to believe the conflict is between two search mods that reside on the site and need a programmer that may be familiar with the clipshare software.

Fast Bulk Import/export
I need a SCRIPT to import products (FAST AND QUICK) with custom attributes and product images into a magento site. The current import and export feature in the admin area is slow and does not allow you to import products with custom attributes it will import the products but it leaves off that part. I don’t believe the current import feature allows you to include the images.

This is an immediate project. Previous project in this regard is necessary to ensure immediate delivery. I need a seasoned Magento professional.

Please stay within the budget when bidding.

Website Cloning: Avatarlog
I am looking for someone to clone Avatar.Starried.net

I need the features for admin as well, such as adding new avatars, editing info etc etc.

Ecommerce Add On
I’m willing to pay $140-$200 for this work. It must be done in 15 days or less.

Application Functions

1)Groupon Functionality
1. Simple & Easy to use webpage to add onto current site built using standard/open source tools
2. Ability to post new deals with following info: deal info, end date/time countdown, min/max order, discount, purchases/purchases needed to activate deal..
3. Option to share the deal on facebook, twitter, email. Refer a friend.
4. Allow cutomers to sign in using Facebook connect and/or login using our already existing login system
5. Facilitate customers to sign-up for a daily e-mail alert
6. Generation of the coupon for successful bids
8. Facilitate secure payment option with direct credit card transactions. Paypal support.
9. User portal which can store groupons bought, payment information.etc

Design of tab

Functions of Website

Admin can log in to admin area

Admin can manage users
Admin can view complete list of users, can delete, disable/enable users

Admin can schedule a deal
Admin can create deal by filling starting date, duration of the deal (in hours, could be more
than 24h), price/number of buyers required, original price, minimal number of groupons and
other fields as described in “Visitor can see a today’s deal”. Optionally Youtube link could be
provided. Scheduled deal will be shown at “Today’s deal” page on provided date. Admin can
manage list of deals, cancel scheduled or active deals.

Visitor can sign in.
Email (to use as login) as well as Paypal email, if differs. User has option to subscribe to “Daily
alerts”

Visitor can sign in using Facebook connect.
Same as “Visitor can sign in”, but Facebook connect is used to populate user profile.

Visitor can log in using Facebook connect.
Facebook connect is used for authentication if user has active Facebook account.

Visitor can see a Today’s deal.
“deal name” including area with current cost of groupon, area with original value of product (“Value”), discount and savings, area “Time Left To Buy” with live countdown,”groupons bought”
area with number of groupons bought, number of groupons needed to the deal to be valid, number
of groupons left, deals banner, “The Fine Print” area, ”Highlights” area. Next large area is for
providing company, including message from the company, company details, optional video,
external reviews and site owner comments. There is a thumbview of “Side deal” on the right.

Visitor can see past deals.
Same as “Today’s deal”, countdown is replaced by end date, and only total number of purchased
groupons is shown. User can still buy groupon if deal is open/active.

User can buy groupon.
On pressing “Buy” button user is directed to confirmation page, where in “Your purchase” area
there are title of groupon, editable quantity, groupon price and total.
In “Payment” area there are list of Ccs set in profile to use, also “Cardholder Name”, “Card
Number”, “Security code”, “Expiration date”, “Billing address”, “City”, “State/province”, “Postal
code” to provide new CC number.
In “where would you like us to send your receipt?” area there is a “email” field.
There are “Complete my order” button and “Never mind” link. On pressing “Complete my order”
button groupon is assigned to user. If new CC was specified, it is added to user profile.

Visitor can buy groupon and sign in at the same time.
Same as for “User can buy groupon”, with addition of “Personal information” area with “Full
name”, “Email”, “Password”, “Password confirmation”, to autocreate new account on “Complete
my order button”

User can view/edit her profile.
On user profile page there are avatar image, name, list of email addresses (manageable), password,
time zone and manageable list of Ccs. Ccs fields are same as for “User can buy groupon”.

User can view/manage her groupons.
User is presented list of groupons, with “Title”, “Price”, “Status” fields. User can sort list by any
field. User can cancel groupons with “Ordered” status.

User can print coupon associated with specific purchased groupon.
By clicking on groupon with “Purchased” status user is presented with a view of coupon and
“Print” button. Pressing button results in printed coupon. Printed coupon must have tracking ID
(most likely hash based on a user profile) and unique serial number on it to prevent naive abuse.

Users are charged for ordered groupons when countdown reaches zero and total
number of ordered groupons is not less then necessary minimum.
Ccs provided for purchase are charged, corresponding groupons get “purchased” status and links to
print coupons. Purchase notifications are sent to provided email addresses. For past deals which are
still active user is charged immediately.

Ordered groupons are canceled if countdown reaches zero and total number of
ordered groupons is less then necessary minimum.
Cancellation notifications are sent to provided email addresses.

User can share a deal on Facebook/Twitter

Admin can view a printable list of purchased coupons for specific deal
A list of tracking Ids for specific deal, handed to the Merchant for the purpose of preventing abuse.

Application sends “Daily alert” email based on template once per day
Users who subscribed to “Daily alert” will get notifications as new deals are added.

This work will require installation and modification of the design that the client wants.