I was able to mass expire sales prices, but I updated them to the incorrect expiration date. Below is my current import that only works when the expiration date is null. I need it to update the specific record IDs that have the incorrect expiration date with the correct expiration date. Any ideas?
Best answer by hayleehicks
Hi
+19Hello Haylee,
If I want to update expired dates only when the expired date = 12/31/2022 for example, I would filter the Expiration Date, send to Excel, and then import the new expiration date using the lines I’ve exported to identify which records to change:
Import scenario will look something like this:
I hope this helps you. (No, it’s not programmatically searching for the proper date; yes you could have a long list of stock item prices in Excel… but it works.) 🙂
Hi
+16This is something similar but I’ve done that with Vendor prices and it works. Here is what I use:
Have you tried to Commit the date? Sometimes that commit checkbox is the culprit.
Hi
+16Can you share your import and I would be happy to test it on my local.
Hi
+19I’m sorry I couldn’t be more helpful - there was just no way I could make time to help test the import for you the past few days. (I’m buried in a client’s sales tax over here in FL.) I’m so glad you figured it out. You are a superstar!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
