Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

  • 0
hilari

Import large product data

Question

Hello !

I´m not sure wether this goes under "technical help" or "tips and tricks..."

I have a list of 1200+ products in my database I would like to transfer to TB. `Thing is that the columns have different naming and order, category, details...etc.

I could rename and re-arrange the sql to re upload the info to TB, but before starting to deal with the nightmare of trying to find what goes where in the new TB database, I was wondering if someone has any experience on this issue and get some useful tips to save time and energy. Any approach would be welcome. Thanks !

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

Different column names are no problem as you can assign columns when you import a csv file.

If you want to insert directly into the database you face a big challenge. At the most basic level products and categories are each present in four tables. 

Share this post


Link to post
Share on other sites
  • 0

So, for the 1200+ products existing in my other database, there is no work around but upload one by one...?

 

Share this post


Link to post
Share on other sites
  • 0

Depends.

If you can export them as csv you can import them as csv. So it depends on your present setup.

There are many tools available that will do the job for you to transfer the data from other webshops. But you will need to provide more details if you want a prescription that fits on your situation.

Share this post


Link to post
Share on other sites
  • 0

Ups I just send you another message. Please disregard whichever you see last.

Where do I go to get the full version of Prestools and how far has it come so far in terms of using it as an integrated plugin inside Thirty bees backend?.

I need whichever version pretty fast.

 

Thank You.

 

Share this post


Link to post
Share on other sites
  • 0

Quick related question: If one imports a quantity of products via a CSV file how are photos added to the products?

Share this post


Link to post
Share on other sites
  • 0
8 minutes ago, dynambee said:

Quick related question: If one imports a quantity of products via a CSV file how are photos added to the products?

Just provide an url in your csv file and make sure that the image are reachable there. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...