How can I bulk update delivery times on my website products?

[JacobStaff70]

Hi Guys 

Whoever can solve this problem for me will be loved.

I have hundred of products on my website all with different delivery dates. 

In stock items are delivered within 10 working days 

Out of stock items going on a pre order with an expected delivery date. 

I get an excel document that shows me the expected delivery date. 

Is there a way I can bulk upload it to shopfiy to change all of the products so I do not have to waste hours going through each product manually. 

My website is below 

https://staffordshireuk.com/collections/staff-top-picks/products/madrid-bedside-table-2-drawers-in-m...

See how just about the description it says "Next Delivery 06/03/22" I have to change this manually for every product and it drives me insane! 

I would love to be able to upload something that changes this and gives it a much cleaner look.

[RobDukarski]

@JacobStaff70 

Yep and a simple solution for that would be to use tags on the products.

You could add the tag like "Expected Delivery_2022-02-06" then in your code you would look for the tag that contains "Expected Delivery" and split it at the "_" and take the last and display it.

Something like:

{% liquid
  for tag in product.tags
    if tag contains 'Expected Delivery_'
      assign date = tag | split: '_' | last
      echo date
      break
    endif
  endfor
%}

You may be able to use the date filter on the date to have a specific output format if you want.

Hope that helps!