Set future Product Availability Date For All Products?

[Webskipper]

Seasonal Shop to open next month. Looking to create future product availability dates for all products.

Change 'Product Added Date' to future date; where?


P i n g u i c u l a . S t o r e

[dbltoe]

Badkup first, but you might want to try

UPDATE products
SET products_date_available = 'yyyy-mm-dd';

Replace the letters for the year, month, and day respectfully.

[lat9]

Badkup first, but you might want to try

UPDATE products
SET products_date_available = 'yyyy-mm-dd';

Replace the letters for the year, month, and day respectfully.

Since the products_date_available is a datetime field, you should also include the time-related elements (00:00:00 through 23:59:59), e.g.

UPDATE products
SET products_date_available = 'yyyy-mm-dd 00:00:00';

[mc12345678]

Seasonal Shop to open next month. Looking to create future product availability dates for all products.

Change 'Product Added Date' to future date; where?


P i n g u i c u l a . S t o r e

Note how the solutions provided reference ths products_date_available field. This field is what is used to control when to let the product become available or to show that it was previously set and has become available.

The field asked about, products_date_added is a different field where the result is simply displayed if turned on. It also helps with identifying what product to show in the new products grouping...

Hiding the product or limiting the interaction of a product until a future date is different than when the product is considered new to the store.

The products_date_available field identified in the sql queries above is found on the product information page towards the top of the page. The products_date_added is generally calculated when the product is added to the database and is not made to be "freely" modified. I mean, once it is added, that's when it was added right? That doesn't mean that there are not other ways to adjust the value. Dbltoe has provided that for products_date_available. A similar query could be used for products_date_added if necessary.

[Webskipper]

Add the code as an sql patch?

Just getting back on the horse; coding.

Thanks in advance.

[mc12345678]

Add the code as an sql patch?

Just getting back on the horse; coding.

Thanks in advance.

One place it can be executed is:
admin->tools->Install SQL Patches

Statement must end with a semi-colon to execute. But remember backup the database before running any of those statements.

[Webskipper]

Well, that worked. Thanks!

"This product will be in stock on Monday dd-mm-yyyy"

Got one success line and one incomplete asking for a semicolon even though it was included as is with the time.

admin->tools->Install SQL Patch

UPDATE products
SET products_date_available = 'yyyy-mm-dd 00:00:00';

[mc12345678]

Well, that worked. Thanks!

"This product will be in stock on Monday dd-mm-yyyy"

Got one success line and one incomplete asking for a semicolon even though it was included as is with the time.

admin->tools->Install SQL Patch

UPDATE products SET products_date_available = 'yyyy-mm-dd 00:00:00';

Yeah, guess no one said to try to enter the content as a single line (even if it wraps around to a new line the absence of a "return" is important).

Hopefully though the yyyy-mm-dd was changed to something like 2021-02-20. :)

[Webskipper]

LOL. Yes, actual date does appear. Just keeping it general for the next programmer.

[Webskipper]

Is there an update to this? Doesn’t work since the PHP update this Summer. Thanks again; in advance.

admin->tools->Install SQL Patch

Code:

UPDATE products SET products_date_available = 'yyyy-mm-dd 00:00:00';