Custom DB to JOOMLA DB import

Cancelled Posted Oct 7, 2009 Paid on delivery
Cancelled Paid on delivery

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 Engineering MySQL PHP Software Architecture Software Testing Web Hosting Website Management Website Testing

Project ID: #2909566

About the project

15 proposals Remote project Active Oct 21, 2009

15 freelancers are bidding on average $262 for this job

honex

See private message.

$255 USD in 2 days
(229 Reviews)
7.6
Euphontec

See private message.

$467.5 USD in 2 days
(188 Reviews)
7.2
robweb2009

See private message.

$21.25 USD in 2 days
(116 Reviews)
5.3
setiawanutama

See private message.

$34 USD in 2 days
(58 Reviews)
4.3
sagarphp

See private message.

$170 USD in 2 days
(34 Reviews)
4.5
best2best

See private message.

$148.75 USD in 2 days
(9 Reviews)
3.9
eissoftechlx

See private message.

$382.5 USD in 2 days
(8 Reviews)
4.5
alambd

See private message.

$85 USD in 2 days
(2 Reviews)
3.1
prosolutionvw

See private message.

$425 USD in 2 days
(8 Reviews)
4.6
hss

See private message.

$85 USD in 2 days
(1 Review)
1.4
freelance09

See private message.

$212.5 USD in 2 days
(2 Reviews)
0.0
ntsolutions

See private message.

$340 USD in 2 days
(0 Reviews)
0.0
melhorvw

See private message.

$382.5 USD in 2 days
(3 Reviews)
0.0
xarishvw

See private message.

$297.5 USD in 2 days
(2 Reviews)
0.0
mostafakhattab

See private message.

$170 USD in 2 days
(0 Reviews)
0.0
rakesh1978sl

See private message.

$471.75 USD in 2 days
(0 Reviews)
0.0