ArtYah Community Forum
Register Calendar Latest Topics Chat
 
 
 


Reply
  Author   Comment  
jillyannajoy

Junior Member
Registered:
Posts: 3
Reply with quote  #1 
I downloaded a csv file of my etsy listings. Then, to try a sample, I copied one row (one listing) into a csv doc and tried to import it in ArtYah. I continue to get this error message: 

"Index was outside the bounds of the array."

Any advice? 

Thanks in advance,

Jolene
0
Christine

Avatar / Picture

Moderator
Registered:
Posts: 379
Reply with quote  #2 
I think that is because you edited the csv file.   Someone suggested deactivating (if practicable) the items  you do not want on Etsy and then exporting csv file, then reactivating them again to get the items you want.  Or you can list them one at a time and use the "similar" option if they are similar to each other
__________________

Kerioak  ~ Original Art  / Nail Art Stickers
Rosemarys Memories ~ A few vintage items
Cottage Crochet ~ Being crochety
Twitter ~ @KerioakArt

0
jillyannajoy

Junior Member
Registered:
Posts: 3
Reply with quote  #3 
Thanks for the quick reply, Christine. Guess I'll need to stop trying to get fancy with my csv files. Especially since I'm in learning mode!! Will work on a full export soon with your suggestions. I'm a beginner all over again! [confused]
0
deescozycreations

Avatar / Picture

Member
Registered:
Posts: 64
Reply with quote  #4 
I exported my entire Etsy shop and then I copy only the items I want to import at one time. 

I haven't had any issues at all doing this.

In fact, there is no reason it shouldn't work unless you are not saving the new file with the correct format or possibly, just possibly your version of Excel is old?

When you copy the rows you want to add to ArtYah make sure you are copying from outside the sheet on the far left side - so you get the arrow.  It's possible if you are clicking and highlighting from within the row that the 'copy' is missing some back end data.  Just a thought.

Hope this is helpful as I know for a fact it works.

If you still can't get it work, may reach out to Craig.

__________________
Creating Handcrafted Crochet Items
https://www.artyah.com/seller/deescozycreations
https://www.instagram.com/deescozycreations
https://www.pinterest.com/deescozy/
http://www.facebook.com/deescozycreations/
https://twitter.com/DeesCozy
0
Christine

Avatar / Picture

Moderator
Registered:
Posts: 379
Reply with quote  #5 
I had exactly the same problem ad jillannajoy when I tried to edit which is why I assumed that was the problem, I don't use Excel but Apache Open Office and it works for everything else.  Maybe should have saved to a MS csv format or something.  Will have to try again
__________________

Kerioak  ~ Original Art  / Nail Art Stickers
Rosemarys Memories ~ A few vintage items
Cottage Crochet ~ Being crochety
Twitter ~ @KerioakArt

0
ProssackDesigns

Avatar / Picture

Junior Member
Registered:
Posts: 3
Reply with quote  #6 
I did a trial run by saving my csv with a new name, and then deleting the items I didn't want to import. Make sure you are saving as a csv, and that your save is not defaulting to another file type.

I also edited my listings on the csv (descriptions, titles) before uploading to ArtYah. That way I'm only having to reformat the text block, make minor tweaks, and set the categories up.

__________________
https://www.artyah.com/seller/prossackdesigns
0
jillyannajoy

Junior Member
Registered:
Posts: 3
Reply with quote  #7 
Oh my gosh, prossackdesigns - clearly this worked for you! I love your marbled paper. 

Thanks for the reassurance; editing my big csv file will be my next project and I'm excited to get started on that. 

Thanks also to deescozycreations for your good tips. 

I'll keep you posted, my friends, and look forward to our time together on ArtYah. 

All the best!!
0
ProssackDesigns

Avatar / Picture

Junior Member
Registered:
Posts: 3
Reply with quote  #8 
You're welcome jillyannajoy [smile] 

Good luck on the the editing - I found it much easier to edit the csv then to edit after importing. Making changes to make descriptions a bit different for each website is always such a joy ([crazy]), keeping them altogether just made more sense to me.

Thank you for the compliment on my work - looking forward to seeing what you'll have here!

__________________
https://www.artyah.com/seller/prossackdesigns
0
Auntmaymesattic

Avatar / Picture

Member
Registered:
Posts: 31
Reply with quote  #9 
Quote:
Originally Posted by deescozycreations
I exported my entire Etsy shop and then I copy only the items I want to import at one time. 

I haven't had any issues at all doing this.

In fact, there is no reason it shouldn't work unless you are not saving the new file with the correct format or possibly, just possibly your version of Excel is old?



What version of Excel do you have?  I guess mine must be really old, because I have Excel 2000.  And how do you copy only the items you want to import?  Not sure what you mean.  Do you cut and paste into a new CSV file?  The CSV file when downloaded is so large, and anytime I change something, such as remove a row then try to redo it, the cells become huge with information. 
Thanks in advance!


__________________
Beth from Aunt Mayme's Attic
"A makeup bag is just a makeup bag; the difference is carrying a piece of vintage with you"
http://www.artyah.com/seller/AuntMaymesAttic
0
deescozycreations

Avatar / Picture

Member
Registered:
Posts: 64
Reply with quote  #10 
Quote:
Originally Posted by Auntmaymesattic


What version of Excel do you have?  I guess mine must be really old, because I have Excel 2000.  And how do you copy only the items you want to import?  Not sure what you mean.  Do you cut and paste into a new CSV file?  The CSV file when downloaded is so large, and anytime I change something, such as remove a row then try to redo it, the cells become huge with information. 
Thanks in advance!



Hi there,

Sorry for the delay.  I don't log into to the forum that often.
I have Excel 2016.
I'll do my best to describe what to do [smile]
1. download your CSV file from Etsy and save it.  This will be your Master - so maybe include Master in the name.  make sure the file type is CSV
2. Next, open a separate excel workbook.
3. go back to your master and find the listings you want to copy
4. put your cursor way out into the far left side of the sheet beside the row you want to copy - so you see an arrow.  Once you see the arrow simply click to highlight the row
5.  now place your cursor anywhere in the row you highlighted and right click and CUT
6. go to your new blank spreadsheet and place your cursor in the cell you want to paste into and then click the the paste button.  In my version I get various options to choose from to paste - you need to choose the one that is Paste Values.  In your version you many have to literally click on Past Options to see this option.  

I think this is where you may be having the issue - if you just clicking the regular paste the data won't come over properly.

You need to do this for each row you want to upload.
Once you have copied over all the listings you want to upload save the new spreadsheet making sure it's a CSV file.

Hopefully that helps.  If you still have issues, let me know and I'll to help further.


__________________
Creating Handcrafted Crochet Items
https://www.artyah.com/seller/deescozycreations
https://www.instagram.com/deescozycreations
https://www.pinterest.com/deescozy/
http://www.facebook.com/deescozycreations/
https://twitter.com/DeesCozy
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.