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 06-07-2013, 11:17 AM
natro's Avatar
natro is offline
 
Join Date: Jun 2013
Posts: 2
Default

Import of Product Variations


Dear Ecwid Support.

I have gone through your post on product variation http://www.ecwid.com/forums/showthread.php?t=14484.

Request: Create a import file to import other variation of the same product

Element 1: Based on the export file which i have made
name: Mixed Shipper
sku: NMS0001
description:
category1:
category2:
category3:
image: http://images-cdn.ecwid.com/images/2.../116420665.jpg
weight: 1.2
price: 0
recommended_price:
quantity:
enabled: yes
shipping_freight: 0
fixed_shipping_rate_only: no
product_url: http://www.natrocine.co.za#!/~/product/id=24539912
product_id: 24539912

+Element 2:
Product Options
Natrocine Revive: 2,4,6,8,10,12 bottles
Natrocine Health: 2,4,6,8,10,12 bottles
Natrocine Extreme: 2,4,6,8,10,12 bottles

+

Element 3: http://app.ecwid.com/api/v1/2230229/product?id=24539912

"galleryImages": [],
"variations": [
{
"id": 3445284,
"sku": "NMS0002",
"smallThumbnailUrl": "http://images-cdn.ecwid.com/images/2230229/116420669.jpg",
"thumbnailUrl": "http://images-cdn.ecwid.com/images/2230229/116420668.jpg",
"imageUrl": "http://images-cdn.ecwid.com/images/2230229/116420665.jpg",
"originalImageUrl": "http://images-cdn.ecwid.com/images/2230229/116420664.jpg",
"price": 4250.0,
"weight": 1.0,
"options": {
"Natrocine Extreme": {
"text": "10 Bottles",
"priceModifierType": "ABSOLUTE",
"priceModifier": 0.0
},
"Natrocine Revive": {
"text": "None",
"priceModifierType": "ABSOLUTE",
"priceModifier": 0.0
},
"Natrocine Health Assist": {
"text": "None",
"priceModifierType": "ABSOLUTE",
"priceModifier": 0.0
}
}
},


+

Help Required: All variations will have unique SKU so based on the SKU for NMS0002 how would I create an import file to populate the variation for product 24539912?

name:
sku: NMS0002
description:
category1:
category2:
category3:
image:
weight:
price:
recommended_price:
quantity:
enabled:
shipping_freight:
fixed_shipping_rate_only:
product_url:
product_id:
  #2  
Old 06-11-2013, 12:42 PM
Matt Ecwid's Avatar
Matt Ecwid Matt Ecwid is offline
Ecwid Team
 
Join Date: Oct 2011
Posts: 4,947
Default

Hello,

It is possible to update existing variations that have unique SKU via CSV import. It is also possible to import product options using the X-Cart format as described here:
http://kb.ecwid.com/w/page/61320633/...productoptions

However, it is not yet possible to create product variations using either regular CSV import or X-Cart format. Sorry. We plan to significantly improve our import tools in the future versions, there is no exact ETA though.

In your case, I'd recommend the following workarounds:
1) If there is a bunch of similar products that you need to add to your store, you can manually create one product with all necessary options and variations and then use it as a base: duplicate it using the 'Duplicate' button in your control panel and modify name/price/weight/description - all the options will be copied to a new created product automatically.
2) Import product options in bulk using X-Cart format and then create variations for each product manually.

Hope that helps.
__________________
Matt K
Ecwid Team

Ecwid Guide for Beginners

Ecwid Help Center

Ecwid video tutorials
  #3  
Old 08-18-2013, 11:27 PM
MBTE's Avatar
MBTE MBTE is offline
 
Join Date: Aug 2013
Posts: 3
Default

Hello, the work around is very complicated specially when there is a need to manually modify Images, Options (color & Size), Stock and Price for every product (near 2000 Products) with 5 or 6 variation each product. Once the product variations are created then we'll have to maintain the stock manually too at least once per week. Any way we can speed up this process please using CSV files, XC, ?? direct access?
  #4  
Old 08-20-2013, 12:57 PM
Matt Ecwid's Avatar
Matt Ecwid Matt Ecwid is offline
Ecwid Team
 
Join Date: Oct 2011
Posts: 4,947
Default

Quote:
Originally Posted by MBTE View Post
Hello, the work around is very complicated specially when there is a need to manually modify Images, Options (color & Size), Stock and Price for every product (near 2000 Products) with 5 or 6 variation each product. Once the product variations are created then we'll have to maintain the stock manually too at least once per week. Any way we can speed up this process please using CSV files, XC, ?? direct access?
Hi,

You can update images, stock and prices for your products in bulk via CSV import as described in this article:
http://kb.ecwid.com/w/page/26373353/...productsinbulk

The same can also be done for those products variations that have unique SKU numbers. As to the product options, you can import them using X-Cart CSV format as mentioned above. Please find more details on updating options/variations in Ecwid in this post:
http://www.ecwid.com/forums/showthre...2074#post62074
__________________
Matt K
Ecwid Team

Ecwid Guide for Beginners

Ecwid Help Center

Ecwid video tutorials
  #5  
Old 08-20-2013, 11:58 PM
MBTE's Avatar
MBTE MBTE is offline
 
Join Date: Aug 2013
Posts: 3
Default

Thank you Matvey for your reply.
what I'm looking for is to import images, stock and prices but for Product Variations.
I did check the post for more information but looks like API still not an option, am I correct ?.

Me again,, I think I found what you mean using X-Cart I'll do some testing. Thanks!

OK. I think I'm back to the original question from natro.

it would be nice to have a way to create a new SKU under Base SKU (under variation) using CSV files.

Last edited by Makfruit; 08-23-2013 at 05:46 AM.
  #6  
Old 08-23-2013, 05:54 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 MBTE View Post
Thank you Matvey for your reply.
what I'm looking for is to import images, stock and prices but for Product Variations.
I did check the post for more information but looks like API still not an option, am I correct ?.

Me again,, I think I found what you mean using X-Cart I'll do some testing. Thanks!

OK. I think I'm back to the original question from natro.

it would be nice to have a way to create a new SKU under Base SKU (under variation) using CSV files.
By means of CSV import, you can update existing variations that have unique SKU. It's not possible to add products or variations via CSV yet.

As to Product API, it currently allows adding products as well as modifying existing ones. However it doesn't allow adding variations at the moment. By the way, we're working on the new version of our API that will significantly extend the existing one - that new API will support adding/updating variations as well.
__________________
Matt K
Ecwid Team

Ecwid Guide for Beginners

Ecwid Help Center

Ecwid video tutorials
  #7  
Old 08-23-2013, 11:25 PM
MBTE's Avatar
MBTE MBTE is offline
 
Join Date: Aug 2013
Posts: 3
Default

Thanks Matvey,
I tried to add the SKU Variation manually and just in a single product I found 68 different colors and 8 different sized.. so just for one SKU I have to create manually the Variations + type the SKU for each. This is practically impossible for more than 1000 products. Ecwid has a lot of PROS but this is big CONS. Anyway I'm happy with what Ecwid offers and very interested to try this new API. Please let me know once it's in place. I'll put on hold my membership for now.

Thanks!
  #8  
Old 05-29-2014, 06:29 PM
Chris Love1:4840147@deleted's Avatar
Chris Love1:4840147@deleted Chris Love1:4840147@deleted is offline
Junior Member
 
Join Date: May 2014
Posts: 1
Default

Has this improvement been made yet?
  #9  
Old 05-30-2014, 07:38 AM
Corwin's Avatar
Corwin Corwin is offline
Ecwid Team
 
Join Date: Jan 2014
Posts: 310
Default

Quote:
Originally Posted by Chris Love1 View Post
Has this improvement been made yet?
Thank you for your question. The improved Product API which (beside other enhancements) will allow to update existing product variations and create new ones is in testing stage currently and will go live as soon as we make sure that it functions flawlessly and is ready to be utilized by all Ecwid users with paid accounts.
__________________
Bulat F.,
Ecwid Team

help portal
  #10  
Old 06-23-2014, 11:55 AM
admin1up's Avatar
admin1up admin1up is offline
 
Join Date: May 2013
Posts: 1
Default

I'm hanging out for the update to the api/import. Are you getting close to releasing it yet?
 
The information in this thread might be outdated
If the solution did not help, please, check our Help Portal or contact Ecwid Team.

Tags
import, import csv, product combinations

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 09:29 AM.
Powered by vBulletin® Version 3.8.11. Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.