Can I bulk upload products?

Introduction

When Connex creates products from QuickBooks to your website, it syncs them one by one. For certain solutions, we can access your database directly and perform a bulk insert. 

What solutions do you support?

We support the bulk insert for WooCommerce. Hosted solutions like Bigcommerce and Shopify do not allow users to access the database directly. For other systems, please contact us.

How do export my products?

To export your productsfrom QuickBooks POS, follow these steps:

  1. In QuickBooks POS, go to File > Utilities > Export.
  2. From the dialog, choose items.
  3. Click export.
  4. Click finish.
  5. Copy the files to your web server.
  6. Enter the file path to the folder in the server image textbox.
  7. In Excel, go to file and click save as.
  8. Choose CSV and click save.

To export your images from QuickBooks POS, follow these steps:

  1. In QuickBooks POS, go to File > Utilities > Export.
  2. From the dialog, choose export file images to a folder.
  3. Under export pictures, choose all items.
  4. Under create file names using, select item number.
  5. Click export.
  6. Click finish.
  7. Copy the files to your web server.
  8. Enter the file path to the folder in the server image textbox.
  9. In Excel, go to file and click save as.
  10. Choose CSV and click save.

How do I import them?

Obtain your database server name, user name, password, and database name from your hosting provider. Once complete, login to Connex. Click configure and go to product import. Here is the form.

Can it import pictures?

Pictures must exist on the internet. Copy them to your website. Woo usually holds images in the /content/uploads folder. On the Connex upload page, enter the URL of your site. If you stored your pictures at http://www.mysite.com/content/uploads/123.jpg, enter http://www.mysite.com/content/uploads.

How do the fields map for WooCommerce?

Here is the mapping:

Spreadsheet Name WooCommerce Notes
Item Number Sku  
Item Name Title  
Item Description Description  
Qty 1 Stock  
Attribute Color Attribute  
Color Size Attribute  
Regular Price Price  
     
Have more questions? Submit a request
Powered by Zendesk