Importing products from CSV into Setary is important to be compatible with other suppliers, you may need to do this daily, so it’s important that it’s easy.
Fortunately you can do this all within Setary.
There are many different reasons you’d need to import, but the 2 main approaches are adding NEW products, or altering existing. Let’s get started.
1. Click Add and Import Products
Find the .CSV file on your local computer. This file will need to be only in CSV format, but can be formatted however you wish. A little tip: if you are editing existing data, we would advise to export WooCommerce products first, and then modify and then import. This way columns are already matched up making this process a lot easier. If this isn’t possible then the next step is to sync columns.
2. Sync columns
The next step is to match your CSV data to the Setary data.
On the left are the Column Titles from your Spreadsheet and the right is the columns that are currently within your Setary view. We will automatically try to match these up, but if not, they will just default to skip, if you don’t have many columns within your Setary view, then most columns will skip.
It’s important to mention, that if you want products to merge then match SKU is mandatory, else products will be imported as new products potentially doubling up product data.
Spend a lot of time at this stage as it’s important, once you’re synced, then you can import into Setary.
Once imported all data will be added above the existing data regardless of whether you are merging data, the merge happens at the next step. Setary should now look something like this:
The beauty of this, is you can now double check your data and make changes if required, nothing has been imported at this point so you can still clear changes if something isn’t right.
3. Import Products
You’re now ready to actually import the products, this will be a familiar process of just clicking SAVE. All updates will now be applied. Any products that required a merge, will merge and any new products will be added.
All done, you’ve just imported products!