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]

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.

[MARKEDWARDS]

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

[RenaeB]

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?

[MARKEDWARDS]

Sure, Below is the document. Thank you.

[MARKEDWARDS]

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

[MARKEDWARDS]

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

[RenaeB]

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.

[RenaeB]

Hello @MARKEDWARDS,

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

[MARKEDWARDS]

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