AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: timlight10 on December 11, 2022, 12:37:56 PM

Title: Import for update only, don't create new products
Post by: timlight10 on December 11, 2022, 12:37:56 PM

Hello, my vendor sends a daily price and inventory file with every single SKU they sell. I do not sell all of their products, but a smaller amount of them. Is it possible to run a product import on this file that only updates the pricing/availability for the products that already exist in my store without creating new products for those that don't exist?

The size of the file is thousands of products.

Title: Re: Import for update only, don't create new products
Post by: Basara on December 12, 2022, 08:01:05 AM

Hello.
Please attach example of CSV

Title: Re: Import for update only, don't create new products
Post by: timlight10 on December 15, 2022, 01:06:13 PM

The file contains confidential information, so I cannot post it here. It's just a standard CSV file with model numbers, SKUs, descriptions, prices, costs, etc... like I've used to import products dozens of times before.

I am looking for an AbanteCart feature, if one exists, during an import of the CSV file, to only update model numbers/SKUs found in the store and NOT import any new products. Is this possible?

Title: Re: Import for update only, don't create new products
Post by: Basara on December 16, 2022, 02:38:27 AM

Hello.
AbanteCart supports two formats of CSV in one of them you can add Action column and control what to do with product
https://abantecart.atlassian.net/wiki/spaces/AD/pages/15007876/Import#Import-ActionInsertorUpdate

Title: Re: Import for update only, don't create new products
Post by: timlight10 on December 20, 2022, 10:04:49 AM

Thanks for the suggestion, I will take a look at that. I have always used the simple import function. I will look at the more explicit option.