7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

Excel into Ecommerce - Any Ideas?

by Fernando Veloso
5 replies
Hi guys

Need some ideas on how to implement a tricky mod:

Grab 1 Excel doc with these columns (name - reference - price - colors - stock) into a ecommerce solution (wp/other).

Any idea of what can work to achieve this?
#ecommerce #excel #ideas
  • Profile picture of the author tryinhere
    I do not know much about the wp e commerce side of it but, i would look at back engineering the problem like this.

    first knowing the medium you want to import to ? wp app, i would first do a trail export of that known application in a format that was used such as a csv file format per say.

    from that we then know that we can import that csv file to the wp app, from there we simply save the excel file as a csv file in the same format as the test / trial export and upload that to the wp app per say.

    if needed / if it were large scale you could write a small macro in excel to create and convert the excel file to the correct / needed csv file format to save time or errors.
    Signature
    | > Choosing to go off the grid for a while to focus on family, work and life in general. Have a great 2020 < |
    {{ DiscussionBoard.errors[4714771].message }}
  • Profile picture of the author Fernando Veloso
    Thanks guys, will see if a programmer friend of mine can follow those guidelines. Hope this post doesn't get nuked too.

    Sheeesh. :rolleyes:
    Signature
    People make good money selling to the rich. But the rich got rich selling to the masses.
    {{ DiscussionBoard.errors[4717218].message }}
  • Profile picture of the author NoGimmicks
    Hi Fernando

    If you don't have an import option in the ecommerce software do you have access to the database that the ecommerce solution runs on (assuming it uses a database, which is highly likely)?

    If you do it'll be easy enough to prepare the csv for a direct import (if needed)
    Signature
    Sick of your products ending up on warez sites?
    Keep an eye out for StealthMarker...
    {{ DiscussionBoard.errors[4718168].message }}
    • Profile picture of the author Fernando Veloso
      Originally Posted by NoGimmicks View Post

      Hi Fernando

      If you don't have an import option in the ecommerce software do you have access to the database that the ecommerce solution runs on (assuming it uses a database, which is highly likely)?

      If you do it'll be easy enough to prepare the csv for a direct import (if needed)
      Thanks for feedback,

      My biggest problem is the amount of different CSV files I'll have to deal with, ie, one with 3 lines (name, description, price) next one with 5, and another one with 4, then try to add pictures to each item, but pictures come in a CD...

      Most probably I'll just skip this project, not into killing my daily plan to deal with all this, and all the confusions I'll have to deal with my client - if that makes sense.

      Signature
      People make good money selling to the rich. But the rich got rich selling to the masses.
      {{ DiscussionBoard.errors[4724137].message }}
  • Profile picture of the author DavidWincent
    If you are using WordPress then import csv file to the WordPress app, from there it is simple to save the excel file as a csv file. It is easy to prepare a csv.
    Signature
    Webmaster Studio -A premier web design and internet marketing company in New York.
    {{ DiscussionBoard.errors[4911404].message }}

Trending Topics