Start a new topic

Import option to remove old products

woul be good to have this option when importing price lists

Update Existing Products and append new products and delete old products


That way old products will be deleted from the database



Yes, this would be nice


When importing a new price list. I put the date into a custom field.

I can then identify those items that weren't updated and then delete those.


Not ideal,  but that does get the end result.


1 person likes this

Definitely would like to have a DELETE ITEMS option when importing.

Matt Rose suggestion does work with a few but it's painful with many items.


1 person likes this

yes we import or update 100,000 products per day from suppliers and would get 100's of obsolete products per week from supplier pricelists so currently have many obsolete products sitting in our QuoteWerks products database

Got a new price list from one of our suppliers today.

Import wizard step3 advanced, mapping selections, notes, manually add a customized note for all with today date or something else unique for this import.

Step 4, I use Update and Append

Field1 in my csv list cross match with QW ManufacturerPartNumber

The I have List and NOTES to update.

I can do the same on other customized field.


After import I went to the product lookup windows and organized by notes column.

It was very easy to see which product were from the new price list and which one are left untouched.

Select those untouched and delete all at once.


This is faster for me than making a discontinued items list to delete on import.

yes but I import pricelists daily and there are 13 of them which I receive from suppliers automatically loaded to an import folder.

all the imports on done via batch/script overnight, so I do not currently do anything manually and don't want to have to.

@Greg Barber, but if you don't mind can you advise how you import via batch/script? We have 4 CSV files we get every Friday morning that I currently import. Interested to know how you do this.


Thanks and sorry I am not providing solutions/ideas for your problem.

@Paul, this is what I use...


Copy this into notepad, replace the variables with your details and save as a .bat file extension.

This will then open QW, run the first import routine, then the second, then the third.


One of my clients imports about 150,000 products each week from multiple suppliers - hits the button to run the routine, goes off and makes a cup of tea, comes back and it's all done without any user interaction.


"FolderPathToQuoteWerksFolder\qw.exe" /u:UserNameHere /p:PasswordHere /i:ImportTemplateNameHere.pit /exit:2

 

"FolderPathToQuoteWerksFolder\qw.exe" /u:UserNameHere /p:PasswordHere /i:ImportTemplate2NameHere.pit /exit:2 

 

"FolderPathToQuoteWerksFolder\qw.exe" /u:UserNameHere /p:PasswordHere /i:ImportTemplate3NameHere.pit /exit:2 


Login or Signup to post a comment