Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Best Practices? Import Features Per Product Via Csv Rate Topic   - - - - -

 
  • Olof
  • Senior Member
  • Members
  • Join Date: 25-Jun 11
  • 209 posts

Posted 20 March 2015 - 10:15 AM #1

We are a manufacturer and so we create all product data ourselves as new products are developed.
All product data is created in Excel. From where it is imported into our ERP system and into CSC via CSV.

But the import of features-per-product into CSC is not yet done. Due to the complexity how CSC handles this. And I'm looking for how others have done this.

Background info
CSC export/import engine puts all features-related-info into 1 CSV field. Rather than separating it into separate CSV fields which would make data-translation to/from other computer systems a lot easier. Please see the example enclosed what I mean

My questions:
1. Where to do the data-translation? Modify the CSC export/import engine? Or create VBA code in Excel? Or...?
2. If we would use API instead of CSV, would the data-translation be more simple?

Any tips or suggestions are more than welcome!
Thank you in advance
Olof

Attached Files



 
  • kickoff3pm
  • Senior Member
  • Members
  • Join Date: 18-Aug 10
  • 682 posts

Posted 20 March 2015 - 03:18 PM #2

I did a few years ago with direct update to the database. But far from easy and involves matching IDs. I supose if you have a dev system you could look at that.
http://matchdaymemories.com - Football Memorabilia Via Cs-Cart V3
http://www.outadwords.com - Free Marketing For You Site.
http://www.alternativestoebay.com - Join The Free Ecommerce Community.

 
  • Olof
  • Senior Member
  • Members
  • Join Date: 25-Jun 11
  • 209 posts

Posted 21 March 2015 - 07:09 AM #3

I did a few years ago with direct update to the database. But far from easy and involves matching IDs. I supose if you have a dev system you could look at that.

Thanks for replying. Could you perhaps give a bit more details on how you did the direct updates to the database?

 
  • kickoff3pm
  • Senior Member
  • Members
  • Join Date: 18-Aug 10
  • 682 posts

Posted 21 March 2015 - 10:53 AM #4

Sorry it's been too long to remember. I suggest you do a few products complete and then look to see which tables in the database were changed.
http://matchdaymemories.com - Football Memorabilia Via Cs-Cart V3
http://www.outadwords.com - Free Marketing For You Site.
http://www.alternativestoebay.com - Join The Free Ecommerce Community.

 
  • Olof
  • Senior Member
  • Members
  • Join Date: 25-Jun 11
  • 209 posts

Posted 21 March 2015 - 04:34 PM #5

Kickoff3pm; ok, I will look around.

Anyone else who can share some experiences and/or tips?
tx

 
  • Olof
  • Senior Member
  • Members
  • Join Date: 25-Jun 11
  • 209 posts

Posted 13 May 2015 - 12:22 PM #6

[bump]
Is there anybody (please... :-) ) who is importing features into CSC (semi)automatically? If so, I would love to hear from you!

At the moment we manually combine (concatenate function in Excel) many data columns into the single & infamous CSC Features field in order to be able to import it into CSC. Very time-consuming and error-prone. We want to move towards automated workflow and I guess we will hire some VBA guru to get it done...

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4482 posts

Posted 13 May 2015 - 01:02 PM #7

I have a similar set up. Our data comes from suppliers with specs, separated in individual cells. I see you are already using concatenate, so do we but we have 1 master sheet for the features with all concatenate functions set in sheet 2 to read whatever we drop in sheet 1 columns.
We also use the combine function amongst others in kutools, try kutools and use the text features, I like it :)

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • Olof
  • Senior Member
  • Members
  • Join Date: 25-Jun 11
  • 209 posts

Posted 13 May 2015 - 01:43 PM #8

Hi Johnbol1,
Thanks for reacting. May I ask how you get your supplier's specs into sheet 1? Just old-fashioned copy-paste or ..?
And I will look into kutools, thanks. FYI, I use several Excel add-ins from this company https://www.add-ins....ata_add-ins.htm

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4482 posts

Posted 13 May 2015 - 02:24 PM #9

Good link, thx

Yes usually copy and paste but for our five main suppliers, we have 5 spreadsheets ready formatted relating to those suppliers formats, thus knowing which columns are which, which isnt tooooooo bad.

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • Olof
  • Senior Member
  • Members
  • Join Date: 25-Jun 11
  • 209 posts

Posted 14 May 2015 - 05:39 PM #10

Good link, thx

Yes usually copy and paste but for our five main suppliers, we have 5 spreadsheets ready formatted relating to those suppliers formats, thus knowing which columns are which, which isnt tooooooo bad.


Ok, thanks for confirmation and tips

 
  • scruft
  • Newbie
  • Members
  • Join Date: 21-Jun 12
  • 4 posts

Posted 05 October 2015 - 06:55 AM #11

For anyone working on this and having trouble: http://forum.cs-cart...ouped-features/