Incorrect Start Availability Date

[MARKEDWARDS]

Hi

I have entered Start Availability Date incorrectly and time is tight, and have no time to unpublish, and publish again, can I upload my excel sheet with the correct date, delist the old one from PI page, and publish it again? If not, is there any other solution?
Thank you so much

[RenaeB · Accepted solution]

Hello @MARKEDWARDS, 

The SDL contains specific formatting within the spreadsheet—DO NOT MODIFY IT.

Changing this formatting will prevent your items from uploading successfully.

I’ve updated the spreadsheet and highlighted the areas that were causing errors:

PI_ITEM Tab:

• Column AT
• Column AV
• Column GO

Please note that anything synced from Item Management CANNOT be changed in Kroger VIP—it MUST be updated in Item Management.

As a reminder, the Start Availability Date, which syncs from IM (Product Information Effective Date/Time), should always reflect the date you are submitting your item.

Please don't hesitate to reach out if you have any further questions. Thank you for being a valued member of the 1WS Community!

[MARKEDWARDS]

Thank you so much for all the helpful info. Could you please also advise how I could have access to the external API for the automation purposes? Thank you again.

And regarding the recent issue, from now on I will just copy/paste my excel sheet to the one with the right format with pasting just the value and will check if the problem with CA upload will be solved or not, so I should just make sure the data type is "text" right? or I have to be cautious about other format details too? I appreciate your time a lot.

[RenaeB]

Hello @MARKEDWARDS, 

A 1WS team member will be contacting you via email regarding the API.

Please do not make any changes to the existing format embedded within the spreadsheet. Only paste values without altering the data type.

[MARKEDWARDS]

Hi There

Do you the reason why I don't see my submitted items in "Retailer" page anymore?
Following is the screenshot of the status. Thank you

[BigBuford]

Hello, 

When items are NOT published/unlisted they will display in "Entered Items", when items are awaiting supplier action they display "In Process Supplier" , from "In Procress Supplier" they then move to "In Process Retailer" meaning they're in the hands of the recipient. If the recipient locates an error it then moved back to "In-Process Supplier" for corrections to be made if no errors are present the item goes from "In Process Retailer" to "Complete" with a "CIC" of " Synchronized". Attached below contains our Kroger Training Tutorials that explain these steps as well. 

https://community.1worldsync.com/t5/Item-Management-Training/ct-p/1WSTrainingIM

Thanks!