Get a Freelance Job

I have a Volusion.com website for ecommerce. They offer sql abilities for processing data. I need someone who can write simple scripts to do various import/exports of data.

I need sql that will write out cvs data files for differnet shopping websites. Google (see below), Amazon, Ebay and others to be determined.

The example script is for Google. However, I wish to make it only export for specific products (flagged).

I will generally want a sql in a day or two.

Example:
SELECT
p.ProductCode AS id
, p.ProductName AS [stripHTML-title]
, IsNull(pe.Google_Product_Type,’n/a’) AS product_type
, IsNull(pe.SalePrice,pe.ProductPrice) AS price
, IsNull(pe.ProductManufacturer,’n/a’) AS brand
, IsNull(pe.ProductCondition,’NEW’) AS condition
, CONVERT(VARCHAR(10), (GETDATE() + 30),120) AS expiration_date
, pd.ProductDescription AS [stripHTML-description]
, ‘Config_FullStoreURLConfig_ProductPhotosFolder/’ + p.ProductCode + ‘-2.jpg’ AS image_link
, ‘Config_FullStoreURLProductDetails.asp?ProductCode=’ + p.ProductCode + ‘&click=2′ AS link

FROM Products p
INNER JOIN Products_Descriptions pd ON p.ProductID = pd.ProductID
INNER JOIN Products_Extended pe ON pd.ProductID = pe.ProductID
WHERE (p.IsChildOfProductCode is NULL OR p.IsChildOfProductCode = ”)
AND (p.HideProduct is NULL OR p.HideProduct <> ‘Y’)
AND (pe.ProductPrice > 0)
ORDER BY p.ProductCode

I have a website that uses a template system (i.e. the html is separate from the php) for all the pages except 2 pages on my website. The first exception is the page that displays all the products from a particular category from a MySQL database. The second exception is the page that displays an individual product page which also takes information from the same database.

I would like those 2 pages to be able to either:
1) use my template system (which means you’ll have to modify the template), or
2) to use a template system that is as easy as the one I currently use, or
3) the Tinybutstrong (TBS) template system, http://www.tinybutstrong.com.

The code has to be updated for PHP 5, if it isn’t already.

I will provide the existing code, so you just have to modify it to make it work, although, you are not obligated to use it.

The 2 pages are:
1) shop-furniture.php from http://www.dianfurniture.com/main/shop-furniture.php?ProductCatalogID=0
- Please note that in shop-furniture.php, the product names are in different cells from the product images. I would like that preserved in the new code. I also want a modified copy of shop-furniture.php that assumes the image and product name are in one cell.

2) itemlisting.php from
http://www.dianfurniture.com/main/itemlisting.php?ProductID=10
- itemlisting.php needs to be modified so that the image table does not go past the last image, or at least does not display a blank row like in ProductID=10. It has to be dynamic based on the images displayed. Right now, it is pre-set with variables in the php.
- I would also like the pagination centered, see
http://www.dianfurniture.com/main/itemlisting.php?ProductID=10&crnt=0&type=1
- itemlisting is not in actual use. It is new code I obtained but have not implemented. The current “production” version of itemlisting.php is prodgenerate.php. You will see that if you browse my website.

I would also like the following:
1) a breadcrumbs row below the main topic headings
2) the code to be commented so I can understand what the major parts of the code are
3) captcha contact page
4) the html template to be simplified. It currently uses a lot of tables embedded in tables. That will require the CSS to be modified as well.
5) my main page to display an rss feed on furniture in the bottom half. I would like this as a simple object that I can use on another page if I want and attach different news.

We have broken down our project into 3 phases. We are requesting proposal quotes for phase 1 &amp; 2 – knowledge on phase 3 maybe benefit bidder .

Basically we are migrating our homegrown PHP backend &amp; Content management system = http://www.deluxecomfort.com to Magento open source system. We have a new features, designs and layouts at http://beta.deluxecomfort.com to implement.

Magento Project layout

Purpose:

Help to migrate our current frontend website and adapt our design to a magento’s theme.
Support for migrating our Backend Data to Magento.
Extend some modules from our Backend to Magento.

Objective:

Adapt our current theme to Magento’s theme
Migrate our data (Customers,Orders,Products,Categories,etc) to Magento
Create new modules to support our specific needs
Goals:
Our goals are divided in 3 phases, first get our site up and running.
Then Move all our information from our old backend system to Magento
Finally, create or extend some modules in Magento from our previous Backend or for filling a new need

Phase 1 (2-3 weeks):

1. Theme

Home Page:
1. Adapt Search Field:: MiniForm in Magento
2. Adapt Categories :: Catalog Navigation Categories in Magento
3. Adapt TopLinks:: Page toplinks Magento
4. Adapt Checkout Cart :: Catalog Checkout
5. Adapt BestSellers :: Catalog Best Sellers
6. Adapt Recently Viewed:: Catalog Recently Viewed
7. Adapt New Items :: Catalog
8. Adapt Featured Categories :: Catalog Categories
9. Adapt Footer Links :: Page footer Links
10. Adapt Banners Design :: ??

Categories Pages:
1. Adapt Show Image &amp; text :: Catalog Categories