Top Menu

Welcome, Guest

TOPIC: export - import

export - import 26 Nov 2015 20:22 #379

Hi,
as i see in demo, i can export to csv.
But if im add 1 line to exported file, i cant import it.

Does that component support importing new products?
The administrator has disabled public write access.

export - import 26 Nov 2015 21:06 #380

Yes.

- You need to enable adding in settings
- id column for product to be added needs to be clear (no value)
- SKU is set in CSV needs to be unique
- slug needs to be unique
- if you are adding variation you need to set parent column appropriately. Just id of parent of parent is also added from same import sku:<parent sku> or slug:<parent slug>

When you prepare CSV like this it will work
The administrator has disabled public write access.

export - import 02 Apr 2016 20:52 #515

Can i ask you for a example?

i want to see working example for 2 products import with:
each product in its own 2nd level category
we dont use SKU (autogenerating?)
product short description
product long description (with chars like ",{,},/,<,\ )
product image (can it be like /images/products/img###.jpg ?)

when i have some products and need to add more products, is it good way to have csv with only new products? or i need to put existing in it too?
The administrator has disabled public write access.

export - import 05 Apr 2016 09:26 #516

We may prepare some videos in future.

What is in CSV that is imported (for update or add) . No deletions are done in import operation.
The administrator has disabled public write access.

export - import 05 Apr 2016 20:16 #517

I dont need any videos, i want to understand before buy,
I have attached modified csv (exported from your demo, edited and uploaded)
as result i didnt see manufacturer and category, so its impossible to create categories or i did something wrong?
Also i didnt see an image and description.


File Attachment:

File Name: csv_to_holest.com_2016-04-05.zip
File Size: 2 KB
Last Edit: 05 Apr 2016 20:17 by pbt39ppc.
The administrator has disabled public write access.

export - import 06 Apr 2016 08:59 #518

I'm not quite sure what are you asking about manufacturers and categories.

In you export yo have columns:

manufacturer_name

and

categories_names

(you also can optionally use categories_paths instead of categories names if you have sub-categories with same name)

Categories and manufacturers must be defined before import, if no match is found during import they will NOT BE CREATED!
The administrator has disabled public write access.

export - import 06 Apr 2016 20:57 #519

So, before import i have to create manufacturers and categories.

If im adding new products, i have to leave VMproductID empty (in that case product will be added)
If the product exists - then it will be updated.
thats right?
The administrator has disabled public write access.

export - import 07 Apr 2016 10:28 #520

Yes if id is empty product will be added (unless SKU is matched but you don't use that).
The administrator has disabled public write access.

export - import 22 Apr 2016 11:18 #530

Hi,
I've purchased VM 'excel like' product manager with UDF plugin and if I tried to export some VM products.
The created CSV file looks wrong.
All columns in the first line, some mysterious signs, etc.
The file will also not imported.
What can I do, what's wrong?
The administrator has disabled public write access.

export - import 22 Apr 2016 12:52 #531

Hi, send that file to support email for check
The administrator has disabled public write access.
Time to create page: 0.046 seconds