Stuck after Shopify Integration: Active profiles jumped from 1,617 (Omnisend migration) to 6,500+ due to historical data sync. How do I fix billing?

Question

Hi everyone,I’m stuck and really need some help from the experts here. I am trying to resolve an urgent data and billing issue before a team meeting tomorrow morning.My Situation:	The Goal: I recently cleaned our database and migrated our 1,617 true, active subscribers via a CSV export from Omnisend.			The Problem: Today, we turned on the Shopify integration. The automatic sync instantly pulled in thousands of historical checkout records.			Current Dashboard Metrics:			Total Profiles: 8,110						Active/Email Profiles: 6,500+			Klaviyo is now reading our account at the 6,500+ billing tier, but our actual marketing list is only 1,617 profiles. The rest are historical Shopify transaction logs that we do not want to mail to or be billed for.I tried building a segment using Properties about someone $\rightarrow$ How they joined/Initial Source to isolate the Omnisend import, but the rules are returning errors/unavailable labels.My Questions for the Community:	What is the fastest, cleanest way to bulk-isolate and suppress these 4,800+ historical Shopify profiles so they don't count toward our active mailable billing tier?			Is there a specific default Shopify integration setting I can toggle off to stop it from automatically marking historical checkout logs as active marketing profiles?	I can't get through to live support right now due to hours, so any quick steps or workarounds to fix this data before morning would be incredibly appreciated!Thank you!

bluesnapper · Accepted Answer

Welcome the community ​@MlolwaRegarding your comments:"The rest are historical Shopify transaction logs that we do not want to mail to or be billed for."Some of these contacts will be prospects and customers who have opted-in at checkout or via another mechanism; so they are a valuable audience to include in Klaviyo. I wouldn’t lose those unless you have good reason. Or if some are very old, create a suppression segement for that purpose."Is there a specific default Shopify integration setting I can toggle off to stop it from automatically marking historical checkout logs as active marketing profiles?"Yes there is with a checkbox: under Klaviyo integrations >> Shopify >> Sync settings >> From Shopify >> Sync data from Shopify >> Sync your Shopify email subscribers to KlaviyoBut why do you want to do that? Klaviyo is your single source of truth. Disabling that sync means customers and prospects will not be added to your Klaviyo list from Shopify.If you really do want to suppress ALL contacts you now have in Klaviyo apart from those 1,617 profiles (and you're unable to confidently identify them), there are a few approaches, but I'd go with the most straightforward:1) Create a segment "if someone can or cannot receive email marketing" and set the condition to "can receive email marketing". That segment will include all active profiles (subscribed and never subscribed).2) View the listing for the segment you just created and select the three dots alongside that segment. Then select "Suppress current members". Note: that will suppress ALL active profiles in your account.3) Re-import your 1,617 opt-in profiles (I always set the list as single opt-in during imports) and during the import select "Yes, update subscription status for all contacts to subscribed" That will flip those1,617 profiles from suppressed that occured in step 2 to subscribed. After the import you will have 1,617 opt-in/active profiles with a status of "subscribed". I suggest you also add a custom property to that import CSV so you can identify these profiles more easily in the future.I also recommend doing a run through of the above on test listI hope that helps!RegardsAndy

Mlolwa · Answer

Hi Andy,Thank you so much! Your breakdown makes complete sense.I took your advice and didn't throw away those valuable checkout contacts. Instead, I carefully isolated and suppressed only the profiles where Accepts Marketing is false. Now, I have a perfectly clean, compliant active database of 5,225 (our original 1,617 + the valid Shopify checkout opt-ins).A huge win!Quick technical question: I am trying to finalize my Abandoned Cart and Post-Purchase dynamic product blocks, but the images and prices are not populating during previews (they just display placeholder question marks).All my flows are currently in Draft mode, so when I hit preview, it only shows my own email profile. Because the flows aren't live, Klaviyo isn't pulling any real event/cart data into the editor to populate the blocks.What is your trick for building and verifying dynamic tables/blocks before a flow officially goes live?This is where I'm completely stuck and I have 2 days to go live.

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials

Scanning file for viruses.

This file cannot be downloaded