If you need to setup a new customer/Discount page on the back-end of the website
Do following
Snip and save flyer.
Upload flyer to Content Management > Media Libraries > Bell Lighting > Promo Images > 2025 Promo Flyers
Go to Content Management > Custom Data Table > Discount
Find and clone existing code.
Change name of cloned code
Change start and end date
Change 'Buy In Offer Alert Text'.
Change 'Promo Short Descritpion' text.
Change 'Promo Discount' text.
Change flyer.
Click Save.
If it’s a totally *NEW* promotion/customer you need to find the customer group in
Phocas > Click “Focus” in top left > export whole customer table from Phocas to excel>
NEW METHOD:
Copy vertical Dataset >"Paste Special" > Transpose > use TEXTJOIN >
=TEXTJOIN(",", TRUE, A*,M*)
*REPLACE A* and M* With specific cell range for data.
OLDER METHOD:
use =CONCATENATE(TRANSPOSE(A1:A174)&",") [A1:A*** whatever number column ends at]
Copy VALUES
Paste into Notepad++
Go to Search -> Replace
Select "Regular expression" under Search mode.
Use \s* for "Find what" and leave "Replace with" blank.
Click Replace all
Paste into customer box group on Discount page
Save