Page 1 of 1

Import Data File from SanMar Catalog

Posted: Wed Aug 31, 2016 4:14 am
by richman123
Hello,

I am brand new to open cart and forums. I hope that I am posting in the correct place. I am a customer of SanMar clothing and would like to import the product catalog data file into opencart 1.5.6. I have OpenTshirt set up and installed with OpenCart but am at a loss for how to import the data file.

If you can help me I would really appreciate it.

Thank you,
Rich

Re: Import Data File from SanMar Catalog

Posted: Mon Sep 05, 2016 12:48 am
by rjcalifornia
Are importing using an .csv file?

I think you have to do everything manually.

Re: Import Data File from SanMar Catalog

Posted: Tue Sep 06, 2016 12:03 pm
by Hannah00
You are a customer of SanMar. Did you have database of SanMar? If you only download image and information for website, it is difficult to import file to new site.

Re: Import Data File from SanMar Catalog

Posted: Tue Sep 06, 2016 1:55 pm
by artcore
richman123 wrote:Hello,

I am brand new to open cart and forums. I hope that I am posting in the correct place. I am a customer of SanMar clothing and would like to import the product catalog data file into opencart 1.5.6. I have OpenTshirt set up and installed with OpenCart but am at a loss for how to import the data file.

If you can help me I would really appreciate it.

Thank you,
Rich
Hi Rich and welcome to the forum.
You didn't specifiy the type of data file but the extension market has lots of good (free) options to import Excel, CSV, XML.
The hard part usually is to match the headers of the reseller feed to opencart's. If you are not tech savvy make sure you find an extension that can map headers.

example opencart -> reseller

manufacturer -> Brand + Title
price -> round(Price * 1.4) / (tax)
image -> Picture

I hope you get the gist of it ;D
It's easy to understand but can be laborious.

Cheers

Re: Import Data File from SanMar Catalog

Posted: Tue Sep 13, 2016 3:29 am
by richman123
rjcalifornia wrote:Are importing using an .csv file?

I think you have to do everything manually.
It is a .csv file

Re: Import Data File from SanMar Catalog

Posted: Tue Sep 13, 2016 3:36 am
by richman123
artcore wrote:
richman123 wrote:Hello,

I am brand new to open cart and forums. I hope that I am posting in the correct place. I am a customer of SanMar clothing and would like to import the product catalog data file into opencart 1.5.6. I have OpenTshirt set up and installed with OpenCart but am at a loss for how to import the data file.

If you can help me I would really appreciate it.

Thank you,
Rich
Hi Rich and welcome to the forum.
You didn't specifiy the type of data file but the extension market has lots of good (free) options to import Excel, CSV, XML.
The hard part usually is to match the headers of the reseller feed to opencart's. If you are not tech savvy make sure you find an extension that can map headers.

example opencart -> reseller

manufacturer -> Brand + Title
price -> round(Price * 1.4) / (tax)
image -> Picture

I hope you get the gist of it ;D
It's easy to understand but can be laborious.

Cheers
Thank you for the help,

Can you recommend any free extensions?

Re: Import Data File from SanMar Catalog

Posted: Tue Sep 13, 2016 4:24 am
by artcore
Import/Export by JNeuhof works fine but you have to map yourself using Excel/Office
Do a search in the opencart extension market and you'll find something free or affordable! I have no recommendations otherwise