support

Author Topic: Import for update only, don't create new products  (Read 3210 times)

Offline timlight10

  • Full Member
  • ***
  • Posts: 124
  • Karma: +15/-1
    • View Profile
    • Dedicated Presentation Solutions
Import for update only, don't create new products
« 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.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5851
  • Karma: +275/-2
    • View Profile
Re: Import for update only, don't create new products
« Reply #1 on: December 12, 2022, 08:01:05 AM »
Hello.
Please attach example of CSV

Offline timlight10

  • Full Member
  • ***
  • Posts: 124
  • Karma: +15/-1
    • View Profile
    • Dedicated Presentation Solutions
Re: Import for update only, don't create new products
« Reply #2 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?

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5851
  • Karma: +275/-2
    • View Profile
Re: Import for update only, don't create new products
« Reply #3 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

Offline timlight10

  • Full Member
  • ***
  • Posts: 124
  • Karma: +15/-1
    • View Profile
    • Dedicated Presentation Solutions
Re: Import for update only, don't create new products
« Reply #4 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.

 

Powered by SMFPacks Social Login Mod