Transform CSV data into OpenCart Products

Quote

Post by IT-Me-Up.co.uk » Thu Sep 21, 2017 4:33 pm

Hi there,

My supplier has sent me a list of products in CSV format, using the following headers:

Code: Select all

Product Number
Manufacturer Number
Category
Manufacturer
Description
Cost
Stock Level
Product Details
Specification
EAN Number
Thumbnail
Main Image
Is it at all possible to use MySQL Workbench to import this data into OpenCart.
I can see the product data is split over multiple tables, how should I best transform my CSV data to match OpenCart for an easy import process?

Thanks in advance

Please Check Out My Site:
https://www.IT-Me-Up.co.uk/

IT-Me-Up.co.uk
New member
Posts
20
Joined
Thu Sep 21, 2017 4:27 pm
Top

Re: Transform CSV data into OpenCart Products

Quote

Post by IT-Me-Up.co.uk » Thu Sep 21, 2017 5:32 pm

I forgot to add I have the Export/Import Module installed and the reason for my question is because I can see the current export uses the following headers just on the Product page, let alone the other tabs:

Code: Select all

product_id
name(en-gb)
categories
sku
upc
ean
jan
isb
mpn
location
quantity
model
manufacturer
image_name
shipping
price
point
date_added
date_modified
date_available
weight
weight_unit
length
width
height
length_unit
status
tax_class_id
description(en-gb)
meta_title(en-gb)
meta_description(en-gb)
meta_keywords(en-gb)
stock_status_id	store_ids
layout
related_ids
tags(en-gb)
sort_order
subtract
minimum
Do I just modify my suppliers CSV to match the Headers from OC?

Please Check Out My Site:
https://www.IT-Me-Up.co.uk/

IT-Me-Up.co.uk
New member
Posts
20
Joined
Thu Sep 21, 2017 4:27 pm
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: JessiesBoutique, pprmkr and 503 guests