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
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
Last edited by Webskipper; 15 Feb 2021 at 12:14 AM. Reason: sp
Cheers!
v2.0+
Badkup first, but you might want to tryReplace the letters for the year, month, and day respectfully.Code:UPDATE products SET products_date_available = 'yyyy-mm-dd';
Are You Vulnerable for an Accessibility Lawsuit?
myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
Free SSL, Domain, and MagicThumb with semi-annual and longer hosting.
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.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Add the code as an sql patch?
Just getting back on the horse; coding.
Thanks in advance.
Cheers!
v2.0+
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
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';
Last edited by Webskipper; 17 Feb 2021 at 12:15 AM. Reason: sp
Cheers!
v2.0+
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
LOL. Yes, actual date does appear. Just keeping it general for the next programmer.
Cheers!
v2.0+
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';
Cheers!
v2.0+
Bookmarks