Jump to content

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

Product Export -Variants Data Rate Topic   - - - - -

 
  • londonman
  • Member
  • Members
  • Join Date: 27-Oct 10
  • 209 posts

Posted 03 January 2019 - 03:30 PM #1

My aim is to know how to upload the product variants via file, so i download the variants files by exporting the demo data, but some data will be erased when i use 'Text Columns'

 

is there anyway to get a original information from the cvs file?

Attached Thumbnails

  • 11.png
  • 22.png


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11266 posts

Posted 03 January 2019 - 08:41 PM #2

Looks like you shifted your columns one to the right.

Without being able to see your header row, hard to identify your issue.

Suggest you export 2-4 products and then show us screen shot of header row and the product rows.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


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

Posted 03 January 2019 - 08:58 PM #3

what separator did you use .

 

Export the data from the site using comma as seperator. then open in excel and it will be in columns. See attached.

Thes can be manipulated easier to text for columns.

 

I also use kootools for excel,  very good :)

Attached Files


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


 
  • londonman
  • Member
  • Members
  • Join Date: 27-Oct 10
  • 209 posts

Posted 07 January 2019 - 03:53 PM #4

what separator did you use .

 

Export the data from the site using comma as seperator. then open in excel and it will be in columns. See attached.

Thes can be manipulated easier to text for columns.

 

I also use kootools for excel,  very good :)

Hi John,

 

Thank you for the reply.

 

I did as your step but get different result.



 
  • londonman
  • Member
  • Members
  • Join Date: 27-Oct 10
  • 209 posts

Posted 07 January 2019 - 03:54 PM #5

Looks like you shifted your columns one to the right.

Without being able to see your header row, hard to identify your issue.

Suggest you export 2-4 products and then show us screen shot of header row and the product rows.

i download the files from the demo