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_idDomain (looked up in sites)
link_typeDofollow toggle
tatTurnaround time (weeks)
content_chargeWriting services price
word_count_minimumMin word count
preapprove_topicTopic pre-approval
accepted_anchor_typesAnchor types checkboxes
marked_as_sponsoredMark posts sponsored
article_styleArticle style prefs
guidelines_urlGuidelines (extracted URL)
guidelines_textGuidelines (full text)
live_linkExample link
site_notesAdditional notes
vendor_notesAdditional notes
review_statusAuto: "pending"
supplier_site_pricing
service_typeguest_post / niche_edit
nichegeneral / cbd / crypto / etc.
costPrice per niche+type
supplier_site_meta
youtube_embedYouTube toggle + price
updates_after_liveUpdates toggle + price
supporting_linksSupporting links + price
permanent_linkPermanent link toggle
link_count_per_postLinks included
monthly_capacityPosts per month
indexedGoogle indexed toggle
do_we_postWe post directly
low_metricsLow metrics restriction
ai_detection_toolAI detection tool name
author_bioAuthor bio required
add_links_to_contentPublisher adds links
client_link_typeAccepted 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