HomeBreadcrumb ArrowModulesBreadcrumb ArrowOpenCartBreadcrumb ArrowExcelPortBreadcrumb ArrowImport product atributes
New Discussion

Import product atributes

User Image
CARLOS LOZADA member
#1 posted on 18/5/14

Hi, there´s any video that explains better the ways to use this module?...

what i want to is i a lil bit complicated:

1.- i export all my complete products from my store with excelport

2.- i need to create Option Values for Each product and they are more than 3k in total...

3.- more of those 3k p. are the same in groups of 4-5 because they are like clothing and dif models per product. for example

sku           product_name     color               size 

2LD001HL  Pullover Hoodie Purple / Black Large  2LD001HM Pullover Hoodie Purple / Black Medium 

4.- like you see here they are the same product (SKU SHOWS THE SIZES) but with two options each one, color and size and the sku is different, so i want to be able to group these items and give them the options and to stay in the same field, like every website does, instead to create a new product with diff options. ( I KNOW THAT I CAN DO IT MANUALLY PER EACH PRODUCT AND THEN EXPORT THEM,... BUT I WILL DIE AND PERHAPS I WILL NEVER END THE JOB LOL).

5.- and final. the provider give me the stock & prices as a one list without the options, just in the same mode that you saw before, so, there´s any way to update just the stock and price list for each sku in automatic way, instead do it one by one?. 

 

THANKS YOU SO MUCH FOR YOUR FUTHER COLLABORATION. 

CARLOS . 

 

 

0
User Image
Mihail Stoychev Admin
#2 posted on 23/5/14

Hi Carlos,

We do not have a video, but we do have a comprehensive 40 page documentation that leads you step by step on how to use the module. 

The currentl version of ExcelPort does not provide you with an alternative method of adding the options besides going to every product. We have logged in your request and will be improving the way in which you can work with the products in quick mode. This will be added to the new version of ExcelPort which will be coming in mid July. 

Hope this helps!

1
User Image
CARLOS LOZADA member
#3 posted on 10/6/14

Hello! sorry that i didn't get back at the time. i'm waitng for you guys to improve the module! :D it would be great to be able to import the whole products and categories at once with the whole especs prices linked to different SKU or product id etc... that would save a lot of time just doing it once and then jus updating the quantities and prices everyday. 

Please let me know when this AMAZING project be ready. :D  

Cheers

Carlos

0
User Image
Mihail Stoychev Admin
#4 posted on 12/6/14

Hi Carlos,

Thanks for your reply.

We will keep you posted.

0
User Image
Mary Luketich member
#5 posted on 1/10/15

I would like a link to the excellent documentation for ExcelPort too.  The tools is very confusing and is not intuitive.  How to add multiple options like size and color is really important and cannot find any help anywhere online!  There should be a blog somewhere about using this tool and tutorials!

0
User Image
Brett Monaghan member
#6 posted on 10/2/16

Is there any documentation on how to use excelport?

I also can not find a way to bulk import options and attributes of each product. 

0
User Image
Teya Veselinova member
#7 posted on 17/3/16

Hello,

You can find a comprehensive documentation and example excel files in the Documentation folder in the module's zip folder.

Also, you can look at this blogpost on how to migrate your store using ExcelPort:https://isenselabs.com/posts/how-to-migrate-from-opencart-1x-to-opencart-2x-with-excelport

I hope this helps!

0