topic Re: Incorrect Start Availability Date in Ask PI Only VIP Questions

Incorrect Start Availability Date

MARKEDWARDS — Mon, 12 Aug 2024 19:42:03 GMT

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

Re: Incorrect Start Availability Date

RenaeB — Mon, 12 Aug 2024 19:49:28 GMT

Hello @MARKEDWARDS,

Welcome back to the 1WS Community!

Could you clarify what is incorrect about the start date and share the GTIN in question?

The Start Availability Date should always correspond to the date you are submitting your data. The most efficient way to update this is by delisting the item, updating the Start Availability Date, and then relisting the item.

I understand the timelines are tight, but following the correct process will be most beneficial.

Re: Incorrect Start Availability Date

MARKEDWARDS — Tue, 13 Aug 2024 12:27:18 GMT

Thank you so much for your response. I just have one more question regarding the error I receive while I'm trying to upload items in PI, and the error says the rows are empty that needs to be field. Do you think any data pool format is the problem? I will attach the photo of the error below. Thank you so much

Re: Incorrect Start Availability Date

RenaeB — Tue, 13 Aug 2024 12:36:35 GMT

Hello @MARKEDWARDS,

The errors seem to be related to the SDL file you attempted to upload. Could you please share the document so I can review it?

Re: Incorrect Start Availability Date

MARKEDWARDS — Tue, 13 Aug 2024 13:31:43 GMT

Sure, Below is the document. Thank you.

Re: Incorrect Start Availability Date

MARKEDWARDS — Tue, 13 Aug 2024 13:36:57 GMT

And the problem is the column orders change every time I try to add data with my own formula. Is there any solution I could have a solid sheet for all my styles?
Thank you

Re: Incorrect Start Availability Date

MARKEDWARDS — Tue, 13 Aug 2024 13:42:01 GMT

Also, I would be thankful if I could have access to your external API for data automation and entry, so workflow would be more streamline in the future if there is any available.
Thank you so much

Re: Incorrect Start Availability Date

RenaeB — Tue, 13 Aug 2024 14:03:27 GMT

Hello @MARKEDWARDS,

After reviewing your SDL, it appears that the information may be incorrectly placed in each column.

I suggest revisiting the SDL upload video to ensure accuracy.

Re: Incorrect Start Availability Date

RenaeB — Tue, 13 Aug 2024 14:03:55 GMT

Hello @MARKEDWARDS,

I will have a team member reach out to you shortly.

Re: Incorrect Start Availability Date

MARKEDWARDS — Tue, 13 Aug 2024 18:43:53 GMT

Thank you so much for the help. and sorry for the confusion, the last one was regarding the API access? Thank you again.

Also, could you please check this sheet format and let me know what is the issue with my items starting with "CA" considered as case pack? Second issue is that after I copy/paste data I should change the date format from text to date all the time to work, is there any other way to solve this issue? Thank you

Re: Incorrect Start Availability Date

RenaeB — Wed, 14 Aug 2024 13:00:00 GMT

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!

Re: Incorrect Start Availability Date

MARKEDWARDS — Wed, 14 Aug 2024 15:40:57 GMT

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.

Re: Incorrect Start Availability Date

RenaeB — Wed, 14 Aug 2024 15:44:55 GMT

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.

Re: Incorrect Start Availability Date

MARKEDWARDS — Thu, 15 Aug 2024 20:06:40 GMT

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

Re: Incorrect Start Availability Date

BigBuford — Fri, 16 Aug 2024 12:37:06 GMT

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!