I am having trouble getting Personalized Catalog V...
# suitecommerce
a
I am having trouble getting Personalized Catalog Views working. 0 items show up now, while I expected at least 3 or 4. If I view the Shop page of the web store normally, it just shows 0 items, even when logged in. If I troubleshoot using Advanced Preview Settings in SMT, I see a 500 error "an unexpected error occurred" on the following URL request:
Copy code
<https://REDACTED.app.netsuite.com/api/personalized/items?as_of_date=2024-11-01T15%3A05%3A23.290Z&c=REDACTED&country=US¤cy=USD&fieldset=search&force_avoid_redirect=true&include=facets&language=en&limit=24&n=2&offset=0&pcv_all_items=F&pcv_groups=-1%2C-2%2C-3%2C1652291&pricelevel=5&sort=relevance%3Adesc&use_pcv=T>
The REDACTED parts are our Sandbox account number. I have been working on it for a few days now. I'm trying to avoid any semblance of having to manually set lists of things, and use the information that's already in NetSuite sandbox to form the segments dynamically. My only item segment is a dynamic Item Collection whose public saved search includes all Item records. My only customer segment is more complicated: • There is a Custom record type "Brand Owner" with two List/Record:Customer fields, "Brand" and "Distributor". The Brand field has Record is Parent = Yes. • The Customer record pointed to by Brand Owner: Brand can see the Brand Owner: Distributor via joins, and they show up in a sublist labeled "Distributors", and can be joined to in saved search results and filters. However, The Customer record pointed to by Brand Owner: Distributor cannot see the Brand Owner record. This is a problem because the Distributor customer records are the ones that will be logging in to the Web Store. • I created a field to point back to the Brand Owner record so that my Customer Segment's Customer Group's saved search can see the Brand Owner, and therefore the Brand Owner: Brand customer record. This works after populating the field on all Brand Owner records via a user event script triggered by CSV import. • A Personalized Catalog View with All Items and the Customer Segment described above, set to "Display Fully", seems to do nothing, despite over 20,000 items showing up in the Items By Customer workbook. If they show up in the Workbook even when I have filtered it by both the Customer Segment and the Customer matching the Distibutor customer I'm logging in with, shouldn't I see all those Items in the Webstore as that distributor Customer? • I realize that most of our items are not set to Display in Web Site, so I turned that on for one of the items, but it still doesn't show up. I can't get this running in a timely manner if I have to rebuild the search index every time I tweak something to see if it works by trial and error. • Web Site is set to Display Uncategorized Items. • Role that logged in users are using has all the permissions levels set the same as the system role Customer Center, plus a few additional ones, except for Reports. But that was after last Search Index rebuild. • At least 2 of the items have Online Price set to a number, and Web Store is confirmed to be using that custom pricing category. I'm going through the troubleshooting guide here: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_1560335048.html#subsect_156700428205 I have checked all the flowchart decision points in that document for one specific item and it should be making it all the way to chart 5's "Item Displays" node. If it does and it still does not display, what then? Here's the Customer Segments Manager: Item Segments Website Visibility Level Customer Segment Unmapped Items Hide Fully --ALL USERS-- All Items Display Fully Webstore Distributor Group - Related Brand Disable Purchase blank Disable Purchase and Hide Price blank
1
c
Hi, I had a similar issue recently and it was a permissions issue on the customer center role. Had to create a new role and switch the Permissions - Lists - Items to none. NS support had told me to change it to view or if it was already view change it to none. This fixed it for me
a
Oh that's weird. So in order to make items visible I have to set the Items permission to None?
c
Yeah thats what worked for me. Very strange
a
I wonder if that was just a cheat-code way to get the search index to rebuild for all items without using up your 2-per-day limit. UPDATE: Yeah that's not it. I checked the search index jobs and nothing new after changing customer center Item permission level.
c
I had tried rebuilding before I went to support and it hadnt fixed it
a
Hmm It doesn't seem to be showing up still, even after rebuilding search index and logging in with the new customer center whether it's Items :View or Items : None permission. The Items all show up in the "Items by Customer" workbook, though, for the logged-in customer.
They show up now; I guess I'm working with out of date PCV configuration application 98% of the time, because anything I change does not show up until I do a full rebuild of the search index, and I can only do that 2x a day.
I can't seem to get the customer segments and item segments to line up in the web store the way they do in the Customers by Item workbook. I changed by CSM so looks like the following: Item Segment Website Visibility Level Customer Segment Unmapped Items Hide Fully --ALL USERS-- Items A Display Fully Customers X Items B Display Fully Customers X and Customers Y Items C Display Fully Customers X and Customers Y and Customers Z The Customers By Item workbook shows A with X, B with X and Y, and C with X, Y, and Z. But if I log in as X, I see Items from A,B, and C. If I log in as Y, I only see B, and If I log in as Z, I only see C Maybe I incorrectly understand how PCV and the CSM work, but this seems backwards to me. So I reversed the CSM table so A --- XYZ, B --- XY, and C ---- Z, rebuilt the search index from the Web Site Setup page, and tried logging in as X, Y, and Z in turn again. Same problem but in reverse. Now I'm not sure if I'm testing the logins on current info or old info anymore. If build search index makes it current in the web store, then does it make it current in the workbook, or does that update based on just saving the CSM? I just want to make it so Customer X only sees Items A, Customer Y can see Items A and Items B, and Customer Z can see all three, Items A, B, and C. Maybe I need to make the Item Segments be the thing that includes the multiple item groups, rather than relying on the CSM's ability to map one Item Segment to multiple Customer Segments. Nope that makes it so X can only see A, Y can only see B, and Z can only see C. That's not what I want, either. Or are the workbooks only fully updated if I rebuild the search index?
UPDATE: Fixed. I had to make each Item Segment include items from A, B, and/or C as desired, and only map each Item Segment to one Customer Segment each. Mapping the groups of items to multiple customer segments wasn't working as expected.
UPDATE 2: I changed the field on customers X,Y,Z to be a multiselect. Now with the CSM table only having one customer segment per item segment, it still interprets each customer as belonging to multiple segments, as many as match up with the multiselect field values on each customer. So now it's working but the reason why is hidden 3 layers deep beneath, in the fact of multiple field values filtered on by the customer segment search used by the customer segment. So we better document that. It's very non-obvious to someone coming in, and I'm likely to forget how and why it works. But this way means I don't have to make the Item Segments include items from multiple customer segment matching criteria. The multiselect field on the customers makes it all turn out right and the item segments can be kept simple and generalized. So now everything is inherently updated in the PCV as we create items and customers, as long as we remember to set the criteria fields on each. We don't have to create item segments for each combination of things we want a customer to be able to access. Just one Item Segment and one customer segment per "brand"
1