New Site Listing — QA Review Form

← Back to Schema Browser

Schema Mapping

How each form field maps to the new loganix_ops database. This form collects the data that populates these tables when a publisher or vendor adds a new site.

supplier_sites
site_id←Domain (looked up in sites)
link_type←Dofollow toggle
tat←Turnaround time (weeks)
content_charge←Writing services price
word_count_minimum←Min word count
preapprove_topic←Topic pre-approval
accepted_anchor_types←Anchor types checkboxes
marked_as_sponsored←Mark posts sponsored
article_style←Article style prefs
guidelines_url←Guidelines (extracted URL)
guidelines_text←Guidelines (full text)
live_link←Example link
site_notes←Additional notes
vendor_notes←Additional notes
review_status←Auto: "pending"
supplier_site_pricing
service_type←guest_post / niche_edit
niche←general / cbd / crypto / etc.
cost←Price per niche+type
supplier_site_meta
youtube_embed←YouTube toggle + price
updates_after_live←Updates toggle + price
supporting_links←Supporting links + price
permanent_link←Permanent link toggle
link_count_per_post←Links included
monthly_capacity←Posts per month
indexed←Google indexed toggle
do_we_post←We post directly
low_metrics←Low metrics restriction
ai_detection_tool←AI detection tool name
author_bio←Author bio required
add_links_to_content←Publisher adds links
client_link_type←Accepted page types

Legacy Source

publishers.loganix.com/new_site.php
3-step wizard → publisher_sites_purgatory → staff reviews → publisher_sites + GPv2

ⓘ

QA Review Form — Not Connected to Database

This form shows every data point collected when a publisher or vendor adds a new site listing. Use it to verify field completeness against the legacy wizard (publishers.loganix.com/new_site.php). Nothing is saved — this is for review by Angelo, John, Lore, and Sara.

Add New Site Listing

All the data a publisher or vendor provides when listing a new site. Each field shows which database column it maps to.

1

Site & Pricing

supplier_sites + supplier_site_pricing
The domain the publisher owns. Auto-checked against existing sites table. No www/http prefix.
supplier_sites.site_id → sites.domain
Each combination of service type (Guest Post / Link Insert) and niche creates a row in supplier_site_pricing.
supplier_site_pricing.service_type + .niche + .cost
Guest Post
Link Insert (Edit)
General
$
$
CBD
$
$
Crypto
$
$
Adult
$
$
Gambling
$
$
Payday
$
$
2

Listing Options

supplier_sites + supplier_site_meta
Dofollow links are NOT marked as sponsored, paid or nofollow.
supplier_sites.link_type
dofollow (unchecked = nofollow)
How many weeks to upload content once provided.
supplier_sites.tat
Publisher provides WP login so we post directly. Faster TAT.
meta: do_we_post
We post directly (requires login credentials)
Can we embed YouTube videos in the content?
meta: youtube_embed + youtube_embed_price
Yes, with optional surcharge
$ surcharge
After a post goes live, can we request edits?
meta: updates_after_live + price
Yes, with optional surcharge
$ surcharge
Internal links on their site pointing at the guest post.
meta: supporting_links + price
Yes, with optional surcharge
$ surcharge
One-time payment for permanent placement. If not, show renewal terms.
meta: permanent_link + renewable_comments
Permanent (unchecked = renewable)
Posts tagged as "sponsored", "paid", etc.
supplier_sites.marked_as_sponsored
Yes, posts are marked
Number of client links per post (excludes supporting outbound links).
meta: link_count_per_post
How many posts they can accept per month from us.
meta: monthly_capacity
No robots.txt or noindex tags blocking indexing.
meta: indexed
Yes, posts will be indexed
Some publishers won't accept sites with low DA/DR/traffic.
meta: low_metrics + low_metrics_charge
Yes, has restrictions
3

Content Details

supplier_sites + supplier_site_meta
A sample published post on the site to verify quality.
supplier_sites.live_link
What types of articles this site accepts.
supplier_sites.article_style
What types of client pages can be linked.
meta: client_link_type
What anchor text styles the publisher allows.
supplier_sites.accepted_anchor_types
Word or character limit on anchor text.
meta: anchor_limit + anchor_limit_details
Yes, has anchor text limits
Publisher's rules for how content should be written. URL is auto-extracted if present.
supplier_sites.guidelines_url + .guidelines_text
Publisher can write content instead of us, at an additional charge.
supplier_sites.content_charge
Yes, offers writing
$ content charge
Must the article topic be approved before writing starts?
supplier_sites.preapprove_topic
Yes, topic must be approved first
"About the author" section at bottom of article.
meta: author_bio
Yes, include author bio
Minimum article length the publisher requires.
supplier_sites.word_count_minimum
After we provide content, do they insert additional internal links?
meta: add_links_to_content
Yes, publisher adds their own links
Which tool they use so we can pre-check content.
meta: ai_detection_tool
Yes, uses detection tools
Anything else — banner ads, social media, special services, restrictions.
supplier_sites.site_notes