Custom DB to JOOMLA DB import

已取消 已发布的 Oct 7, 2009 货到付款
已取消 货到付款

I have this custom shopping cart, which has products in 14 categories... The 12 Categories are tables, so I have the following 14 tables :

top 5

necklaces

sets

canadian

silver

bracelets

earrings

rings

scarves

handbags

kids

purse

must haves

mens

Each table has the following fields:

ID, Item_Number, Picture, Short_desc, long_desc, A, B, C, D, E, F, G

(a being the item price and b, c, d... being resellers prices)

What I need to do is to import the data contained in this to Joomla VirtueMart.

So, as Virtuemart takes 3 tables to store all the info contained in my one table, we'll have to get creative with the import.

so for the 14 tables, we'll have to :

**bring in the virtuemart table vm_product**

ID --> vm_product.product_id

Item_number --> vm_product.product_sku

picture --> vm_product.pruduct_full_image

short_desc --> vm_product.product_s_desc

long_desc --> vm_product.product_desc

and add to this

vm.product.pruduct_publish = Y

vm.product.product_name = short_desc from my custom DB

**bring in virtuemart table vm_product_price**

price --> [url removed, login to view]

and add

vm.product_price.product_price_id = ID

vm.product_price.product_currency = CAD

**bring in virtuemart talbe vm_product_category_sref**

product_id --> ID

and add

category_ID = one of the 14 categories we're importing

product_list = 1

This should be fairly easy for someone who knows what they are doing.

Don't have a big budget.

## Deliverables

* * *This broadcast message was sent to all bidders on Saturday Oct 3, 2009 11:51:13 AM:

The nature of this bid request has been changed. Please review the details of the new project and remove your bids if no longer interested. Thank you for your interest.

CSS 工程 MySQL PHP 软件构架 软件测试 网络主机 网站管理 网站测试

项目ID: #2909566

关于项目

15个方案 远程项目 活跃的Oct 21, 2009

有15名威客正在参与此工作的竞标,均价$262/小时

honex

See private message.

$255 USD 在2天内
(229条评论)
7.6
Euphontec

See private message.

$467.5 USD 在2天内
(188条评论)
7.2
robweb2009

See private message.

$21.25 USD 在2天内
(116条评论)
5.3
setiawanutama

See private message.

$34 USD 在2天内
(58条评论)
4.3
sagarphp

See private message.

$170 USD 在2天内
(34条评论)
4.5
best2best

See private message.

$148.75 USD 在2天内
(9条评论)
3.9
eissoftechlx

See private message.

$382.5 USD 在2天内
(8条评论)
4.5
alambd

See private message.

$85 USD 在2天内
(2条评论)
3.1
prosolutionvw

See private message.

$425 USD 在2天内
(8条评论)
4.6
hss

See private message.

$85 USD 在2天内
(1条评论)
1.4
freelance09

See private message.

$212.5 USD 在2天内
(2条评论)
0.0
ntsolutions

See private message.

$340 USD 在2天内
(0条评论)
0.0
melhorvw

See private message.

$382.5 USD 在2天内
(3条评论)
0.0
xarishvw

See private message.

$297.5 USD 在2天内
(2条评论)
0.0
mostafakhattab

See private message.

$170 USD 在2天内
(0条评论)
0.0
rakesh1978sl

See private message.

$471.75 USD 在2天内
(0条评论)
0.0