1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Merging / Appending CSV file

Discussion in 'Databases' started by jack2006, Dec 20, 2009.

0
  1. #1
    Hi There,

    I have received 3 files from my dropshipper. All in csv format.
    One contains the categories.
    Two contains products.
    Three contains product to category accociation. (sku:1111 is in category:2)

    I have uploaded the categories to my virtuemart shop. Now I'd like to upload the products.

    But the product file as i mentioned above does not contain the product/category associations. So i need to merge or append (don't know what is the appropriate term here), the second and third file so the categories are matched to the sku in the second file.

    How can i do that? I am totally stumped.

    Thanks for any help

    Cheers,
    J
     
    jack2006, Dec 20, 2009 IP