Remove sourced products with import

Follow these instructions to remove multiple sourced files from your inventory using a CSV file

Avasam can remove SKUs from your inventory in bulk using a  CSV file. This is a text file, but can also be opened and edited in a spreadsheet such as Excel. this can be faster and easier than removing them manually, one at a time.

  1. In Avasam, open the settings menu.
  2. Select 'imports'.

    Imports
  3. Click on the add configuration button.
  4. Next, name the import for later reference.

    Add Import
  5. Select 'bulk delete products' from the import type drop-down list
  6. If you aren't sure of the import file's format, then click on the link to 'download CSV template'. This will give you the correct headings and an example of the content it contains.
    1. You only require 2 headings - SKU and delete.
    2. If the contents of the delete column for a SKU is yes, then the SKU will be removed from your inventory.
    3. If the contents of the delete column is no, then that row will be ignored.
  7. Once your file is ready, click on the upload button.
  8. Select your file and click 'open'.
  9. Click the analyse and map button for Avasam to process your CSV file. When complete, Avasam will update the relevant view. 
  10. Check the data preview to ensure you selected the correct file. If not, then return to step 6.
  11. You need to ensure that the data from the CSV file will be imported into the right place. This takes place in field mapping.
  12. When Avasam recognises the heading of a field in the file, it will map it to the corresponding field.
  13. If the field is mapped incorrectly, you can delete the mapping by clicking on the 'x' beside it.
  14. Any CSV fields not mapped will be found in the CSV field drop-down list.
  15. Select the field to map from the list, then select the field it should be mapped to in the map to list. Next, click the map field button to apply the mapping.
  16. Repeat steps 14 and 15 for all fields you want to be imported.
  17. When complete, click the button marked 'add configuration'.
  18. You will be returned to the imports screen, and see a list of currently available import configurations with their status. 

    Import configs

add-cofiguration