The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.
 
 
Thread Tools Display Modes
  #1  
Old 09-04-2012, 07:31 PM
Mandalas's Avatar
Mandalas is offline
 
Join Date: Jun 2012
Posts: 6
Default

Any updates on Exporting CSV with Options / Variations?


I know this question has been asked many times, but I still can't seem to find a working solution.. Our store has over a thousand products that utilize options / variations, which we need to do batch edits on. From reading the forums and KB here, it is NOT possible to export/import products with options / variations.. Is this still true?? From a few of the other posts I've read, the Ecwid moderators have said they are "currently working on this feature and will be in the next release." These posts date back over 2 years. Where is the release with this update?

I also found some threads saying "As a workaround, you can develop special script, which will get the full list of your products (with options) using our Product API and save it in CSV file as you needed." However I have no idea how this is done and can't find any tutorials in the KB on how to implement this (also the average user should not have to write their own PHP script, that's why we pay you), can't you implement this into our dashboard somehow?

We desperately need a way to do batch edits! I know I'm not alone on this. Any help or update on this matter would be greatly appreciated as soon as possible! Thanks!

Thanks for your time!
The Following User Says Thank You to Mandalas For This Useful Post:
  #2  
Old 09-05-2012, 09:46 AM
Matt Ecwid's Avatar
Matt Ecwid Matt Ecwid is offline
Ecwid Team
 
Join Date: Oct 2011
Posts: 4,947
Default

Quote:
Originally Posted by Mandalas View Post
I know this question has been asked many times, but I still can't seem to find a working solution.. Our store has over a thousand products that utilize options / variations, which we need to do batch edits on. From reading the forums and KB here, it is NOT possible to export/import products with options / variations.. Is this still true?? From a few of the other posts I've read, the Ecwid moderators have said they are "currently working on this feature and will be in the next release." These posts date back over 2 years. Where is the release with this update?

I also found some threads saying "As a workaround, you can develop special script, which will get the full list of your products (with options) using our Product API and save it in CSV file as you needed." However I have no idea how this is done and can't find any tutorials in the KB on how to implement this (also the average user should not have to write their own PHP script, that's why we pay you), can't you implement this into our dashboard somehow?

We desperately need a way to do batch edits! I know I'm not alone on this. Any help or update on this matter would be greatly appreciated as soon as possible! Thanks!

Thanks for your time!
Hello,

You're right, the built-in import/export tools in Ecwid are currently limited as they don't include the whole set of product features. In particular, at the moment it is unfortunately not possible to export product options and variations. It is, however, partially possible to update the variations data via standard CSV import, I will get to it below in this post.

First, let me, please, describe the workarounds you can currently use for eporting/importing the product options.

1. Export options and variations.
As you mentioned in your message, product options and variations data is returned by Product API - this could be used as a workaround. For example, plese have a look at this output provided by Product API:
http://app.ecwid.com/api/v1/1264039/product?id=13328443

It represents one of the products in your store and contains the product's options and variations as well. That data can be obtained in some custom script and formatted in the desired way so that will produce a CSV (or any other format) as a result. Though there isn't a ready general-purpose solution for that. If you decide implement such thing, you will probably need to develop it yourself or hire a developer.

2. Import options.
As you probably know, it is possible to import product options in Ecwid in the X-Cart format (Control panel → Catalog → Products → Import products → 'X-Cart' tab). The details are here:
http://kb.ecwid.com/w/page/27124243/...%20and%20Ecwid

You can also find the examples of using this feature on the forums. Please refer to these threads, for example:
http://www.ecwid.com/forums/showthread.php?t=963
http://www.ecwid.com/forums/showthread.php?p=24731

3. Import variations.
For those product variations that have their own SKU numbers, it is possible to import data via standard Ecwid import procedure. In order to do it, you will need to specify variations SKUs in the SKU column of import CSV file - the data you put in the import file's line will automatically update the corresponding variation in your store. This way, it is possible to update weight, image, price and quantity of a variation via CSV import.

I'd like to note that we understand your frustration on the matter and we really sorry for the troubles. We of course agree that abovementioned workarounds often require extra efforts and, in some cases, even programming skills. We surely know that many of our clients really need an easier and more convenient way to do it. The lack of extended import/export features in Ecwid worries us as well so we will surely improve the import tools in one of the future Ecwid versions. However, we cannot provide any ETA on this yet. Sorry.
__________________
Matt K
Ecwid Team

Ecwid Guide for Beginners

Ecwid Help Center

Ecwid video tutorials
The Following User Says Thank You to Matt Ecwid For This Useful Post:
Mandalas (09-11-2012)
  #3  
Old 09-21-2012, 06:28 PM
Holly and Martin Advertising's Avatar
Holly and Martin Advertising Holly and Martin Advertising is offline
 
Join Date: Aug 2012
Posts: 4
Default

This was very helpful for us to get product options to import using the X-Cart! However, do you know how to set the option to be required if the option is a custom text field? The setting is visible in the API, but I cannot import with the option details using X-Cart import - I tried a few things on a hunch, including the below, but to no avail.

Thanks for any help!

[PRODUCT_OPTIONS]
!PRODUCTCODE,!PRODUCT,!CLASS,!TYPE,!OPTION,!REQUIR ED,!PRICE_MODIFIER,!MODIFIER_TYPE
37-128-033-1-23,Buy Now Button - 24 Cans of FireGlo Gel Fuel,Your Website (ex: Website.com),TEXTFIELD,TRUE,TRUE,0,Absolute
37-128-033-1-23,Buy Now Button - 24 Cans of FireGlo Gel Fuel,Link URL (ex: website.com/products/289030924),TEXTFIELD,TRUE,TRUE,0,Absolute

Sorry for the double post - this thread seemed more relevant.
  #4  
Old 09-24-2012, 01:53 PM
Kess's Avatar
Kess Kess is offline
Senior Member
 
Join Date: Feb 2012
Posts: 2,071
Default

Product API let you get the data fron Ecwid, but not pass them to Ecwid. X-Cart does not use such a column, thus unfortunately X-Cart import does not let importing this parameter.

Last edited by Kess; 09-24-2012 at 01:55 PM.
  #5  
Old 05-16-2013, 08:36 PM
Daniil Chernenko's Avatar
Daniil Chernenko Daniil Chernenko is offline
Senior Member
 
Join Date: Jun 2011
Posts: 319
Default

but is it any way to update variations with no different SKUs?
It is not important for me is SCUs different or now - but how to add first empty variations (in batch mode)?
  #6  
Old 05-20-2013, 09:24 AM
Matt Ecwid's Avatar
Matt Ecwid Matt Ecwid is offline
Ecwid Team
 
Join Date: Oct 2011
Posts: 4,947
Default

Quote:
Originally Posted by 1330.ru View Post
but is it any way to update variations with no different SKUs?
It is not important for me is SCUs different or now - but how to add first empty variations (in batch mode)?
It is not yet possible, unfortunately. Please vote for this idea in order to get it implemented sooner:
http://ideas.ecwid.com/forums/22031-...ort-variations

We've also replied to you here:
http://www.ecwid.com/forums/showthre...5294#post85294
__________________
Matt K
Ecwid Team

Ecwid Guide for Beginners

Ecwid Help Center

Ecwid video tutorials
  #7  
Old 04-25-2014, 04:25 AM
The GOJC's Avatar
The GOJC The GOJC is offline
Junior Member
 
Join Date: Jan 2011
Posts: 17
Default

Quote:
Originally Posted by Mandalas View Post
I know this question has been asked many times, but I still can't seem to find a working solution.. Our store has over a thousand products that utilize options / variations, which we need to do batch edits on. From reading the forums and KB here, it is NOT possible to export/import products with options / variations.. Is this still true?? From a few of the other posts I've read, the Ecwid moderators have said they are "currently working on this feature and will be in the next release." These posts date back over 2 years. Where is the release with this update?

I also found some threads saying "As a workaround, you can develop special script, which will get the full list of your products (with options) using our Product API and save it in CSV file as you needed." However I have no idea how this is done and can't find any tutorials in the KB on how to implement this (also the average user should not have to write their own PHP script, that's why we pay you), can't you implement this into our dashboard somehow?

We desperately need a way to do batch edits! I know I'm not alone on this. Any help or update on this matter would be greatly appreciated as soon as possible! Thanks!

Thanks for your time!
Please vote for this feature! Someone has suggested it!

http://ideas.ecwid.com/forums/22031-...orted-with-the
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:01 PM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.