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

Store Design
1

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-matt-black

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.

2

@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!