We're here to serve you!
M-Th 9am - 5pm EST | Fri 9am - 12pm EST | Sun 11am - 3pm EST
sqlAttributes: select distinct avm.AttributeMappingID,AttributeName,av.AttributeNameId,AttributeValue, type,cssProperty, isnull(avm2.linkedto, isnull(avm22.linkedto2,0)) isLink, coalesce(spg.GroupName, spg1.GroupName) SubProductGroupName, coalesce(coalesce(spg.isMainGroup,spg1.isMainGroup),0) isMainGroup, av.AttributeValueId, attributeValueName, avm.isDefault, avm.Price, controlType, attributeGroup, Explanation, isnull(avm.linkedTo,0) linkedTo, isnull(avm.linkedto2,0) linkedTo2, an.sortOrder, avm.MappingId, avm.MapType, av.sortOrder valueSortOrder, coalesce(om.MappingId, avm.MappingId) OutlineMappingId from AttributeValuesMapping avm inner join AttributeValues av on avm.AttributeValueId = av.AttributeValueId inner join AttributeNames an on an.attributeNameId = av.attributenameid join SubProductGroups spg1 on spg1.productid = 455 and spg1.ismaingroup = 1 left join SubProductGroups spg on avm.MappingId = spg.GroupID and spg.ProductID = 455 left join AttributeValuesMapping avm2 on avm2.linkedto = av.AttributeValueId and avm2.MapType = 1 and avm2.ProductID IN (455,465) left join AttributeValuesMapping avm22 on (avm22.linkedto2 = av.AttributeValueId) and avm22.MapType = 1 and avm22.ProductID IN (455,465) left join AttributeValuesMapping avm3 on (avm3.AttributeValueId = avm.linkedto and avm3.isDefault =1 and avm3.ProductID IN(455,465)) left join AttributeValuesMapping avm4 on (avm4.AttributeValueId = avm.linkedto2 and avm4.isDefault =1 and avm4.ProductID IN(455,465)) left join OutlineMapping om on om.outlinemapid = avm.MappingId and om.MapType = 2 and om.productID = 455 where avm.productid In(455,465) and avm.MapType = 1 /*and coalesce(isMainGroup,0) = 1*/ and (avm3.AttributeValueId is not null or isnull(avm.linkedto,0) = 0) and (avm4.AttributeValueId is not null or isnull(avm.linkedto2,0) = 0) order by an.sortOrder,an.attributeGroup,av.AttributeNameId, av.sortOrder
sqlAttributes: select distinct avm.AttributeMappingID,AttributeName,av.AttributeNameId,AttributeValue, an.type,cssProperty, isnull(avm2.linkedto, 0) isLink, sub.subproductname SubProductGroupName, 0 isMainGroup, av.AttributeValueId, attributeValueName, avm.isDefault, avm.Price, controlType, attributeGroup, Explanation, isnull(avm.linkedTo,0) linkedTo, an.sortOrder, avm.MappingId, avm.MapType, av.sortOrder valueSortOrder, coalesce(om.MappingId, avm.MappingId) OutlineMappingId from AttributeValuesMapping avm inner join AttributeValues av on avm.AttributeValueId = av.AttributeValueId inner join AttributeNames an on an.attributeNameId = av.attributenameid inner join SubProducts sub on sub.SubProductId = avm.MappingId inner join SubProductGroups spg on sub.GroupID = spg.GroupID left join AttributeValuesMapping avm2 on avm2.linkedto = av.AttributeValueId and avm2.ProductID IN (455,465) left join AttributeValuesMapping avm3 on (avm3.AttributeValueId = avm.linkedto and avm3.isDefault =1 and avm3.MapType = 2 and avm3.ProductID IN (455,465)) left join OutlineMapping om on om.outlinemapid = avm.MappingId and om.MapType = 2 and om.productID = 455 where avm.productid IN (455,465) and avm.MapType = 2 and sub.Required = 1 and (isnull(avm.linkedTo,0) = 0 or avm.linkedTo IN (803,77,100,79) or avm3.AttributeValueId is not null) order by coalesce(om.MappingId,avm.MappingId), an.sortOrder,an.attributeGroup,av.AttributeNameId, av.sortOrder

Bar Mitzvah Invitation Style 20 SKU: bminv200

  • STEP 1:
    Choose Main Options
  • STEP 2:
    Your Design
  • STEP 3:EDIT
    Review & Checkout
Make your selections from the Customizations panel on the right and click NEXT
Please choose carefully as once the invitation is designed there is additional fee to change styles or fonts.
Please scroll through this preview and ensure that your information is correct to forward to our design specialists to create a mockup for you. Feel free to add notes and comments in the area provided.
Need Help?
Our invitation specialists are happy to assist you! Please call 732.947.3597 M-Th 9-5 Fr 9-2 EST
Upgrades shown in image above: Taupe Ink

Invitation Size: Princess (5.5" x 8.5")
Additional Cards Size: A1 (4.88" x 3.5")

Additional paper options (stock, weight, color and size) are available upon request (at additional cost).
Ask us about foil stamping and embossing options.

Customizations

Choose paper options

Choose ink options



Choose other options



Choose additional items

These will be customized on Step 2

Selected Options

Customizations:
Main Quantity (invitation & envelope): 100$214.55
Total Price: $214.55
Deposit Required: $100.00
A non-refundable deposit of $100 is required to initiate the design process. This will be credited towards your final balance.
Prices do not include shipping costs.
Hebrew Keyboard
Choose Options
Missing Information
Please enter your personal details in the highlighted fields. Verify that all wording is accurate.
© 2024 - BP Invitation Loft - All Rights Reserved